Importing large Tab-Separated-Value Sheets into my access DB,

[PaulHilgeman]

Well, development is done and it is time to import all of my 12000
entries that I need to retain from quickbooks into access.

What is the recomeded way of doing this.

Last night, I tried just creating an .xls file and found that I
received an error when I tried to import into an existing table, but
importing into a new table worked fine.

I then tried to copy and paste the colums from the successfully
imported table into the existing table.

I was able to get through about three colums before I got an error
saying that I needed to increase a value in my registry. I quadroupled
what it was, and restart the computer. I then proceeded to try again
and it failed at the exact same point.

Last, I just tried importing the TSV file, again, with no luck.

Any suggestions on how best to do this?

Thanks,
Paul

 

[Guest]

I've done it before, with up to 9000 records, using the xls method. Make the
1st columns in the sheet the same as the field names in the table, and format
the columns the same as the fields in the table. What error message are you
getting?

 

[PaulHilgeman]

Actually that did it.

It needs to be EXACT.

I was hoping that access would provide some sort of mapping from the
colums in the SH to the DB, but you just need to make it exactly the
same.