Hello,
I have a problem importing a file with around 3 million records.
I get a csv comma delimited file with no quotations from an external source.
It contains consumer data with demographics and personal details. However, the address field contains commas (but not all records).
This means that if I try to import the file, then I'll get a lot of import errors because of this.
For example, the file contains:
id,date_of_purchase, date_of_drop_off,name, address, postcode
1, 01/01/2005 00:00:00, 03/01/2007 00:00:00, John Thomson, 342/3, London Street, Birmingham, B32 1FG.
In this case, the data look fine if I open the file in Excel (but, of course, not all of them will appear as it doesn't accept more than 1million records). But, if I import them into Access, then the second part of the address will move incorrectly into the postcode field.
Any ideas how to import it successfully but keep the commas in the address field?
Thanks!
I have a problem importing a file with around 3 million records.
I get a csv comma delimited file with no quotations from an external source.
It contains consumer data with demographics and personal details. However, the address field contains commas (but not all records).
This means that if I try to import the file, then I'll get a lot of import errors because of this.
For example, the file contains:
id,date_of_purchase, date_of_drop_off,name, address, postcode
1, 01/01/2005 00:00:00, 03/01/2007 00:00:00, John Thomson, 342/3, London Street, Birmingham, B32 1FG.
In this case, the data look fine if I open the file in Excel (but, of course, not all of them will appear as it doesn't accept more than 1million records). But, if I import them into Access, then the second part of the address will move incorrectly into the postcode field.
Any ideas how to import it successfully but keep the commas in the address field?
Thanks!