Update SQL Server with MS-Excel

[sasa888]

Hi all, I have never done this before. Is there a way to use Ms-Excel connect to SQL server and the add rows into a table within SQL Server? Thanks for your helps in advance.

 

[SkipVought]

Hi,

Set a reference in the VB editor to MS ActiveX Data Object Object Library.

Set a connection and recordset object.

with the recordset object you can add and update.


Skip,
[sub]
[red]Be Advised![/red]
A wee deranged psychic may be runnin' around out there!
SMALL MEDUIM @ LARGE[/sub]

 

[sasa888]

Hi Skip, do you have any example that I can follow? Thank You!

 

[SkipVought]

Check out VB help on ADO.

Also

http://www.microsoft.com

has some how-to and other examples.


Skip,
[sub]
[red]Be Advised![/red]
A wee deranged psychic may be runnin' around out there!
SMALL MEDUIM @ LARGE[/sub]