Macros to update source data

[sumera12]

Hi,

I am trying to create a database that will analyse cost of sales for my business. So every month I download an excel file from BEX (Business warehouse), I want to link this file to access. I was wondering is there a VBA code that I can write that would update access database with new data every month?

Thanks

Sumera

[ranman256]

No vba code needed.

Save the xl file to the same place , same name everytime....xlFile2Import.xls
Link it into the db as a table.
build a query to add that data to your access table. qaImportXLdata
add this query to a macro : mImportXLdata

so now the steps are:
1. save xl wb to xlFile2Import
2. run macro
3. done.

[sumera12]

how do i build a query to add the data to access table?