View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Dan[_31_] Dan[_31_] is offline
external usenet poster
 
Posts: 5
Default Help with Excel and MS Sql Server

Thanks for the quick response Tom. Let me be more specific.

I can't easily install the other files since it is a work computer and is
handled by the companies main office. The chance of getting them to approve
the upgrade in any efficient time is unlikely. What I am trying to do
exactly is to query a database that my company is connected to retrieve
information on particular items. My store contains product information
within a sql database which i need to query with a textbox in order to fill
an array which will later be used for creating shelf signs.
i have all the databse information (I believe) to acess it, I just need to
figure out how to achieve this.

I don;t really know much about ado or dao and how ot use them to connect,
but i will start researching them now. Thanks again.
Any other help or information would be greatly appretiated.

Dan Butler


"Tom Ogilvy" wrote in message
...
Get External Data requires installation of MSquery. Why not just bring up
the office install program and install the other files that you need.

There are other methods of getting external data, such as ADO and DAO.

Also, Microsoft recommends against using Office products server side
(because it is designed to be user interactive by nature). I don't know
what you intend to do, however.

--
Regards,
Tom Ogilvy

Dan wrote in message
news:rNiOb.26199$Ar1.11698@fed1read04...
Hi, I am writting a excel form that is hopefully going to connect to a

sql
database. However i have run into an interesting problem. I haven;t

actually
figured out how exactly to do it yet, but that should be easy since

there
is
an abundance of good posts on the subject. One thing I am concererned

about
however is that the computer at work which i must run the form off is
running Win2k server with functional , but incolmplet version of Excel

2K.
When it was installed they didn't include unnecessary files such as vba

help
and perhaps more importantlyThe access referenc files and such. I don't

know
exactly how much of the install is actually there. The reason in know

this
is because i can't quere a database using the "Get External Data"

command.
It says that the necessary files were not installed.

Anyways, my question is this: Will i still be able to connect to the sql
databse under VBA? If I can't is it possible to include the needed files
with my .xls for it to connect?

I'm very new to this database connection stuff and i don't want to get

far
just to be stopped by something small. Any Help would be great. Thanks

alot

Dan Butler