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

Unrecognized database format 'S:\xxx.accdb' (Microsoft Jet Database Engine) 0
VBA - exporting serial letters to single documents 0
Export Spec Problem 1
Exporting a text file WITHOUT the field names (header row) 3
TransferSpreadsheet method question 2
ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0
Reading data from https:// server 0
Missing info when exporting report to txt file 2

Top