Linking to SQL tables

[dday01]

Hi All,

I am using ACCESS to link to SQL server tables to query and create a report. I initially tried to import the tables and I got an "Invalid arguement" error. I then tried to link to the tables and was able to do so. I created a query and I can run the query and get the result, however when I go to save the query I get the same "Invalid Arguement" error. The tables I am linking to are very large, could this have something to do with it? I am very frustrated and any suggestions are welcomed.

Thanks,

D

 

[smedvid]

If the data is that large, consider writing a SQL Server Stored Procedure that executes a Query on the server. This query can perform a Make Table to create a table on the server.

Once you have a table on the server, you can easily write a little extract routine to dump the file to a text file (CSV or Tab Delimited). I've used DTS under SQL Server to do this, but I am sure there is another way.

Also review Pass-Through queries as an alternative. Pass-Through queries run under the server.

Steve Medvid
"IT Consultant & Web Master"

http://www.saveourfarm.com

Chester County, PA Residents
Please Show Your Support...

 

[dday01]

Thanks Steve good suggestion I think I can use the passthrough method.

Thanks,

D