MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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


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...

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