Access won't Import into a Table?

[eyal8r]

Access 2002.

Hey guys-
I have a software program that I am exporting data out of into excel (it's SQL based). From Excel, I then am importing into Access into an existing table previously created from a similar file (same columns, just different record sets). I am running into problems when importing files...

If I import into a new table, and have Access create the table based off of the Excel file- it works fine. If I try to import more records into this same table, it tells me it failed to import and that an error occured (no error's table created, no error number given). If I delete the original records in the table, and re-import the SAME RECORDS that were originally imported to create the table- it doesn't work. It will only import my files if it creates a brand new table for each import, every time.

Can Access not import into an existing table? It should- but I dont get what's going on here. I have tried DBF, HTML, txt files- all the same results. I really don't want to have to create a new table each time- as now my Queries will have to be updated everytime I create a new table. Can you please help?

 

[eyal8r]

Well- here's the problem. Sometimes when I import into a new table- it gives me an error and creates an error table. Basically, it doesn't import all the records. I guess Access tries to assign field types to the data based off of the 1st row in the file. But then in later records- those fields don't match up properly, so it throws that data into a separate table. This completely sucks.

So that's why I tried to create a 'Master Table' for importing the raw data. I designated the fields the way they should be so it wouldn't error out during the import. Thus, creates my problem- as now it won't allow the import into an existing table. What a pain. Any solutions to this?
Thanks