Archive of Mr Excel Message Board

Back to Other Office and Excel archive index
Back to archive home

export

Posted by jim on February 13, 2002 3:08 PM

Hello

I’m trying to find a way (quick way) to export about
2 thousand worksheet into existing access table or
(Import them from Access)
Both access and excel are 2000 and there is few common
Key between them? Any idea

Thanks

Re: export

Posted by Andrew G on February 14, 2002 5:59 AM

It's too involved to go into any detail here, but my preference would probably be to use the ADO (ActiveX Data Objects) object library to "move" the data.

You would be opening an ADO connection to both the Excel wkbk and the Access db, then running a SQL query to do the work. Something like:

INSERT INTO Table1
SELECT Sheet1.*
FROM Sheet1

I'm probably way over-complicating this for you - I just happen know more about ADO than I do about Access automation, which may be the way to go...

Re: export

Posted by jim on February 14, 2002 9:06 AM

thanks for reply
i know some about ADO not too much ,, i have
to work on it
thanks again
jim

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.