importing spreadsheet data

[MelanieP]

i have to import sales figures from a branch to head office. the import facility in ms access 2.0 only allow for 1 table although the data that needs to be imported needs to be done into two tables. how would i be able to do that appending the data to a query already setup to bring in the data. it is just to import the data from the spreadsheet to the two different tables.

thanks melanie

 

[Sergeant]

What I do is import the spreadsheet to its own table "tblImports" and then run queries within the db to distribute the data. Every time I do a new import, it overwrites the old tblImports table. This way you have source data for most recent import. You could also delete the table in code after the queries run.

docmd.transferspreadsheet (arguments...)
docmd.openquery (queryname)
docmd.openquery (queryname)

 

[MelanieP]

Thank You

Thanks it really helped