Appending data to the already imported data

[MI man]

Hi,

I have an Access form through which I import the data from Excel spreadsheet (by assigning Docmd.transferspreadsheet to a Command Button). However, this should be the case when the database is empty.

The probelm: I have to transfer the data on a daily basis. So for the first time when the database is empty, I would directly import through the above method, but how to further append the data from the next day...??

Many Thanks...!!!!

 

[MStef]

Try to do it via an Append query, (in another table).