Newbie Q: OpenRecordset from Excel

  • Thread starter Thread starter ijb
  • Start date Start date
I

ijb

Check out ADO as a starting point via yahoo.
Full db connectivity is available via ADO

--
If I've mis-understood the question please tell me.

HTH

ijb

Remove nospam from my e-mail address to talk direct

Not MCSD, MVP, TLA, P&P, PCMCIA, etc just trying to help
 
Hi all!

I've got an Access macro and i need to change it to Excel. :(

Is there any way i could connect to SqlServer database and use
openrecordsets and stuff like that?

Please, any help is welcome!

Vinicio
 
Before starting to Program your own code with ADO..
check out Excel's QueryTables.

Data/Import External Data/New DB Query.

(and it helps to ensure that MSQuery is installed)
it's optional in Office Setup.)


keepITcool

< email : keepitcool chello nl (with @ and .) >
< homepage: http://members.chello.nl/keepitcool >
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

E-mailing from Excel Q 13
Creating a VBA Range object from Excel HYPERLINK workbook function 1
Excel & VBA & SQL - Bob Phillips please 2
I'm a newbie...pls help 1
SMB or NBT issues on VPN 5
Auto Fill Program needed to get maps from internet onto excel 1
Dynamic Data binding 2
Computer Associates sells their customer e-mail list to Tiger Direct 14

Back
Top