Access Drops File Extensions on Import

[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

 

[Ken Snell \(MVP\)]

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

 

[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