The best way to import data from Access (Performance) ??

kleysonr

Guest

Posts: n/a

14th Aug 2008

Hi

I have a table in Access with many records. So i need import those records
to Excel.
I need keep Access table and Excel syncronized.

For each row imported in Excel a have a formula that use the datas to
compare the datas with datas from a DDE Link in Real Time.

What's the best way to import from Access, looking for performance and
keeping formulas working during the import process ?

« Macro for Opening Reuters, Opening Excel File, Closing Excel File | Some Excel dates can't be imported into sql server? »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Memo format field data problem - Data import from Access database	AFSSkier	Microsoft Excel Programming	0	29th Apr 2009 05:51 PM
ado.net data access performance	John	Microsoft ADO .NET	22	4th Mar 2008 05:01 AM
ado.net data access performance	John	Microsoft VB .NET	22	4th Mar 2008 05:01 AM
ANN: New Article: Improving Data Access Performance with Data Caching		Microsoft Dot NET Compact Framework	0	21st Sep 2007 05:14 PM
Import Data From Access to Excel - Return Modified Data To Access	HVG	Microsoft Access External Data	0	9th Dec 2005 08:00 PM