SQL..... from EXCEL???

[miffe]

Is it possible to INSERT from Excel on one PC to Access (.MDB) on another PC?

How could I do this? Do I have to perform some kind of connect/disconnect like on php-mysql but from VBA? Or how can I update information on the DB remotely...

Let's say I have an excel worksheet that gathers info from the DB, and then I have to output some info back to it... like client info, etc... I know how to gather the info initially, I just connect and update fields in excel... then I made a macro to do it automatically... But how can I update the DB remotely.. from Excel?


Thanks -
Miffe

 

[miffe]

I'll restate my question in a simpler form:

Is there a way to INSERT values in a .MDB using SQL from EXCEL including cells from a workbook?

Via which method? VBA? Query editor?

Thanks a lot, a quick example would be appreciated,
- Miffe

 

[SydneyGeek]

Hi Miffe,

Yes you can do it using ADO. Here is the first working example I put together... http://www.mrexcel.com/board2/viewtopic.php?t=114080

You need to set a reference in the Excel VBE to the Microsoft ActiveX Data Objects 2.x library (or Microsoft ADO 2.x) for this to work.

Performance over a network is quick -- several hundred records a second is typical.

Denis

 

[miffe]

thanks

thanks a lot, seems just perfect, didn't know that about the reference to the active x control - this will just do!

have a great day... or night (who knows what time it is in australia :S)
- miffe