Link Excel 2003 named range to Access 2003 Table

  • Thread starter Thread starter SSweez
  • Start date Start date
S

SSweez

I am trying to create from Excel 2003 a link to a Access 2003 table. I
then wan to append that linked table to another table and have the temp
table deleted. This is in an effort to find the most effecient way to
insert a lot (1,000 -1 ,500) records from Excel into Access with the
most speed. The problem is that the code I have found on the web does
not seem to work with Excel 2003. Can anyone help me with the correct
code. Thanks in advance.

-Scott
 
hi,
You don't need code. in excel, give your data a range name.
in access go file>get external data>link tables.
in the file name box at the bottom select excel files.
brouse to the excel file you wish to link to and double click.
in the wizard, select "show named ranges" and select your named range then
just follow the rest of the wizard.

regards
FSt1
 
Back
Top