Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
leamas
Starting Member
2 Posts |
 Posted - 2011-02-01 : 10:11:32
|
| Hi,I'm new to SQL Server and I'm trying to establish a link to some text files via Server Management Studio for the first time. I have tried just about every permutation of inputs I can think of but I still get the same error;Cannot initialise the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "server_name",OLE DB provider "Microsoft.Jet.OLEDB.4,0" for linked server "server_name" returned message "Unspecified Error". (Microsoft SQL Server, Error; 7303)Can anybody give me a clue?Also, I'm not entirely sure whether an Excel.csv file is treated as a text file or an excel file?Thanks in advance...Leamas |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2011-02-01 : 10:50:08
|
| Can't you export Text Files to SQL Server? Why Linked Server??? |
 |
|
|
leamas
Starting Member
2 Posts |
Posted - 2011-02-01 : 11:09:24
|
quote:
Originally posted by sodeep
Can't you export Text Files to SQL Server? Why Linked Server???
Hi,These files are bringing in fresh data, once per min 12hrs a day. Firstly I wanted to query the files in SQL via SQL server, secondly I need to replicate and sychronise the files elsewhere and finally I need to merge them with other files. It seemed the easiest way to do this was to add them as a linked server?M |
|
|
|
|
|
|
Linked Server to CSV files