Exporting Data

S

s_wadhwa

Hi,
I'm using SQL Server 2000 with Access (.adp format) as frontend. I want
to export data from select query from 3 tables in SQL Server to a text
file using some user Interface in Access forms.
Previously when I was working in .mdb format I used TransferText method
to export data from Access Query to .txt file, but Now TransferText
method does not recognizes the view I have created in SQL Server.
If anyone can tell how should this be done. Thanks for any suggestions
and comments.

Shalini
 
J

Jeff Boyce

Shalini

Link from the Access front-end to the view in SQL-Server. Create a query
against the link-view.

Now you can use the TransferText method.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 

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

sending query result to text file 2
Exporting Data 1
Exporting a text file WITHOUT the field names (header row) 3
Export Spec Problem 1
TransferSpreadsheet method question 2
Export Results of Access 2000 query to text file. 2
How do I keep leading zeros and remove the decimal point when expo 2
column header problem when exporting -- need # character 4

Top