Export delimited text

[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,

 

[Jackie L]

Kenny,

Is vwStdCMPullMinusPRC (dbo) the name of your query?

 

[Gina Whipp]

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 G]

Yes, that is the name of the query and I can open it in the Access database.

 

[Gina Whipp]

Kenny,

Try doing the Export manually and report what happens...

--
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 G]

Ginna,

I exported it as a .txt file and it opened in notepad.

 

[Gina Whipp]

Kenny,

With headers?

--
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 G]

Gina,

Yes, the headers were on the txt document.

 

[Gina Whipp]

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

 

[Kenny G]

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

 

[Gina Whipp]

Kenny,

Then do create export specs... I have no explanation why it will not export
with headers. When I try in in Access 2003 and Access 2007 it works.

--
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 G]

Ms Gina,

Done and thanks.
--
Kenny G

Kenny,

Then do create export specs... I have no explanation why it will not export
with headers. When I try in in Access 2003 and Access 2007 it works.

--
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 Whipp]

Kenny,

I gather from your response it's working now?

--
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 G]

Yes, and thanks!
--
Kenny G

Kenny,

I gather from your response it's working now?

--
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 Whipp]

Glad to help!

--
Gina Whipp

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

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

 

[io]

Ms Gina,

Done and thanks.