Import from Excel is changing every field Format to @

[khughes46]

To get data from a 3rd party website I have to export it into an Excel spreadsheet. When I import this file into Access the Format in all the fields are changed from no entry to "@". All the fields imported are defined as text, even numbers and dates. I can live with that but not the Format change. Is there a way to either prevent this at import time, or correct it en mass after import? Thanks for any help or suggestions.

[June7]

Are you importing to new table or existing table?

It is possible to use VBA and TableDefs to modify field properties. I do that to modify AllowZeroLength property. Example:

CurrentDb.TableDefs("tablename").Fields("fieldname ").AllowZeroLength = False

However, I am not seeing the Format property available. Gets a little more complicated. Review http://answers.microsoft.com/en-us/o...?page=~pagenum~

Although in your case you want to delete the format property, not create it.