Exporting Data

  • Thread starter Thread starter s_wadhwa
  • Start date Start date
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
 
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
 
Back
Top