Automatically import excel data into Access table

[petho]

Hi,

I'm relatively new to access and am trying to set-up an automatic way of importing the data within excel files, into an access table.

For example, the excel files are in the following format:
Name,Age,Address,Occupation

We have hundreds of these files generated each day, therefore, I'd like to place them into a folder (ie c:\people\) and an access table populate with the following info:
"Filename",Name,Address,"CurrentDate"

Is this possible using some basic code?

Thanks,
Simon

 

[namliam]

Use the docmd.Transferspreadsheet statement. Look it up in the help for more details.

 

[amawad98]

adding data from website automatically

have a similiar issue as i need to add data from a website to my excel sheet every five minutes. the table can be reached through the following link:

http://www.fxstreet.com/rates-charts/exchange-rates/

how can i build such a query that adds the new data but not delete the old but to continue keeping it.

many thanks