Importing from Excel

[Guest]

I have an Excel table that has fields that are over 255 characters long. I
want to import this table into an Access database, but the import function of
Access selects it as a text field, and as such I lose a lot of information (
ie anything that is over 255 characters long). The import wizard does not
allow me to change the field type.

Can anyone help, as I'm going to go nuts pretty soon!

Thanks

Phil

 

[Ken Snell [MVP]]

The import process via File | Get External Data ... | Import uses the EXCEL
95 (EXCEL 5.0) format...meaning no strings longer than 255 characters nor
more than 16384 records.

Use a macro or VBA code to run the TransferSpreadsheet method. That allows
you to choose a newer version (e.g., EXCEL 10 [EXCEL 2002]) format. See Help
for more details about how to use it.