Access Drops File Extensions on Import

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
 
K

Ken Snell \(MVP\)

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

Ron2006

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
 
Top