View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] SSweez@gmail.com is offline
external usenet poster
 
Posts: 12
Default Link Excel 2003 named range to Access 2003 Table

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