LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5
Default Help with Excel and MS Sql Server

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



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel and SQL Server Rob Excel Discussion (Misc queries) 1 May 5th 10 07:18 PM
SQL Server -- Bulk Insert from Excel to SQL Server Madhan Excel Discussion (Misc queries) 0 December 12th 06 03:08 PM
Excel 2003 Error Cannot Locate the Internet Server or Proxy Server Seabee Excel Discussion (Misc queries) 0 November 20th 05 12:03 AM
problem updating link from Novell server to windows server #REF er Ellen Excel Discussion (Misc queries) 0 May 10th 05 09:18 PM
Excel as RTD server? Boon Excel Programming 5 December 30th 03 11:22 AM


All times are GMT +1. The time now is 10:11 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"