Export delimited text

  • Thread starter Thread starter Kenny G
  • Start date Start date
K

Kenny G

Access 2007 (Access Project) & SQL 2005

Below is a simple export of a query I need to use to export Current Data.

Private Sub cmdExportData_Click()
DoCmd.TransferText acExportDelim, , "vwStdCMPullMinusPRC (dbo)",
"C:\temp\CurrentData.txt", True
End Sub

I get the following message as a result: Run Time Error 7874 Microsoft
Office Access can't find the object 'vwStdCMPullMinusPRC (dbo)'

Will someone please tell me what I am doing wrong.

Thanks,
 
Kenny,

Is this the name of the query in Access "vwStdCMPullMinusPRC (dbo)"? And
can you open it in Access? If that is the name of the view on the Server
and there is no link, Access can't read that.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm
 
Kenny,

First try refreshing links, if that doesn't work.... Then I am going to
strongly suggest you recreate the export specifications from scratch. Even
though you believe them to be correct there must be something wrong.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm
 
Gina,

Going back to my original post, there is no specs written for the export.
See below, the specs portion of the DoCmd has a comma in place of the specs
portion.

Private Sub cmdExportData_Click()
DoCmd.TransferText acExportDelim, , "vwStdCMPullMinusPRC (dbo)",
"C:\temp\CurrentData.txt", True
End Sub
 
Back
Top