trying to import data from excel

[pm]

I've created a table named register...importing the data from Excel. The
data includes bank account information that I want to import on a daily
basis. I tried to append to the existing data in the table and am receiving
the error - "an error has occurred to import file-- - the file did not
import. The Excel file format I am importing from does not change. I've
checked the field names and data type's in Access and Excel - - they are the
same.....
Does anyone have any suggestions???? Thanks.

 

[Rui]

depending on your requirements you could just had the excel spreadsheet to
access as a linked table.

Regards
Rui

 

[pm]

I am comparing the bank data with a store register file. The data that
doesn't match for that day leave as outstanding to compare with the next days
bank activity. So I think- - at least how I understand linking - will not
work for me. If you link the excel file that data is not kept in the access
database, correct? So, I would not be able to compare the remaining
outstanding excel file to the next day's bank file....

 

[Rui]

yes, you are correct. But I would suggest that you then create a table and
copy the excel contents accross. A simple select * into

from
[excel_table] should do the trick.

Rui

 

[pm]

I'll try that...thanks.

yes, you are correct. But I would suggest that you then create a table and
copy the excel contents accross. A simple select * into

from
[excel_table] should do the trick.

Rui

I am comparing the bank data with a store register file. The data that
doesn't match for that day leave as outstanding to compare with the next days
bank activity. So I think- - at least how I understand linking - will not
work for me. If you link the excel file that data is not kept in the access
database, correct? So, I would not be able to compare the remaining
outstanding excel file to the next day's bank file....