LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
importing/linking data from an Access 2003 Query to an Excel 2003 PerryK Excel Discussion (Misc queries) 2 August 24th 09 07:06 PM
Link to Access & Named Range Jessica Excel Worksheet Functions 11 July 10th 09 02:34 PM
opening excel files from access 2003, win xp, office 2003 Nugimac Excel Discussion (Misc queries) 2 April 26th 07 12:32 PM
import Excel 2003 file into Outlook 2003 - NO NAMED RANGES?? lewisma9 Excel Discussion (Misc queries) 0 February 27th 07 12:23 AM
Transferring Large Amount of Data from Excel 2003 to Access 2003 [email protected] Excel Programming 3 January 12th 07 05:48 PM


All times are GMT +1. The time now is 11:38 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"