Import errors

[Roosters]

When importing a column from excel formatted to text that contains predominantly number entries all cells with text entries are not imported (blank), only the cells with the number entry are imported. This has had me stumped for a while, I would appreciate any idea's.

Thanks Phil

 

[Databaseguy]

Yeah, when importing, and especially when linking, Access doesn't like changing data types in a columns.

Hightlight the offending columns, go to format, column, and choose a data type. Most likely text in your case... Tyrone Lumley
augerinn@gte.net

http://server105.hypermart.net/databaseguy