try to move data from excel to access

[associates]

Hi,

I was wondering if i can get some help here. The aim here is moving data from excel to Access '03.

At the moment, i'm having troubled in finding out a way to open a database and execute SQL - insert the data into the table.

Set cn = New ADODB.Connection
With cn
    .Provider = "Microsoft.Jet.OLEDB.4.0"
    .ConnectionString = "Data Source= C:\Mydocuments\myDB.mdb;Extended Properties=Excel 8.0;"
    .Open
End With

then, i got stuck in here whereby i need to execute the SQL insert command to insert record to the table.

Appreciates your help greatly

Thank you in advance

 

[Oldsoftboss]

If you are moving data FROM excel, then this should be in the Excel thread.

If you want to import data from Excel, when using Access, then I maybe able to help.

Dave

 

[cat001969]

Is there a reason you are not going to file --> get external data? Is this a one time import or is it an import that you need to do on a regular basis?

 

[rsmonkey]

maybe he wants to import via use of forms.. if so look up the transferspreadsheet command!

 

[Oldsoftboss]

Thus my question. Is this being done when using Excel, not Access?