Access Drops File Extensions on Import

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mike Proffit - 29 Sep 2006 22:02 GMT

I'm importing an excel spreadsheet into an Access table. One of the fields
is a filename, formatted as general, e.g.:

\\delphi\home\hwlab\SHIPLOG\3806-0002-CM2-02.ship.report.092106

When that field comes into Access, it drops everything to the right of the
first ".", so the Access field (data type = text) says:

\\delphi\home\hwlab\SHIPLOG\3806-0002-CM2-02.ship.

I happens even when I put a single quote in the excel sheet before the file
name/path.

How can I bring in the whole string?

Thanks much,
MikeP

Reply to this Message

Ken Snell (MVP) - 30 Sep 2006 02:05 GMT

You may need to put " characters around the string in the EXCEL file's
cells, and then do the import.

Signature

Ken Snell
<MS ACCESS MVP>

> I'm importing an excel spreadsheet into an Access table. One of the fields
> is a filename, formatted as general, e.g.:
[quoted text clipped - 13 lines]
> Thanks much,
> MikeP

Reply to this Message

Ron2006 - 11 Oct 2006 18:24 GMT

Are you REALLY sure that the field length is more than 50

If you count the characters, that is the number of characters there
(50).

Ron

Reply to this Message