Hi There
I'm an intermediate Access user trying to import a large CSV file to a Table using the macro "transfer spreadsheet" function. The csv has about 50 fields - all are imported OK except for one ID field. The offending csv field contains numbers (eg "123456") and text (eg "none" or "new"). When imported by the macro, the text values are rejected and thrown into an Import Errors table for type conversion.
I've tried amending the format of the recipient Access table to be text or memo, but it still happens.
Can anybody help solve this problem.
Many thanks
Simon
I'm an intermediate Access user trying to import a large CSV file to a Table using the macro "transfer spreadsheet" function. The csv has about 50 fields - all are imported OK except for one ID field. The offending csv field contains numbers (eg "123456") and text (eg "none" or "new"). When imported by the macro, the text values are rejected and thrown into an Import Errors table for type conversion.
I've tried amending the format of the recipient Access table to be text or memo, but it still happens.
Can anybody help solve this problem.
Many thanks
Simon