Access Drops File Extensions on Import

  • Thread starter Thread starter Mike Proffit
  • Start date Start date
M

Mike Proffit

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
 
You may need to put " characters around the string in the EXCEL file's
cells, and then do the import.
 
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
 
Back
Top