2007 - error exporting to text file

[Guest]

I am sorry to post this here but I have had no response from two postings on
the Import/Export Data forum...

We have a regular monthly process where we open some tables from data
providers in an Access DB and need to export the table data to a delimited
TEXT file.

We have updated some PCs to Office 2007 and now encounter an error on these
machines using the Access 2007 export wizard :
"The specification xml failed to validate against the schema. There is an
error in the following line of the XML document: ."

Any assistance much appreciated.

Jane

 

[Cinzia]

I am sorry to post this here but I have had no response from two postings
on
the Import/Export Data forum...

We have a regular monthly process where we open some tables from data
providers in an Access DB and need to export the table data to a delimited
TEXT file.

We have updated some PCs to Office 2007 and now encounter an error on
these
machines using the Access 2007 export wizard :
"The specification xml failed to validate against the schema. There is an
error in the following line of the XML document: ."

Any assistance much appreciated.

Jane

Hi Jane,
peraphs this may help:

1)Open the table you want to export
2)Select External Data from Ribbon Toolbar
3)Select Export to TXT File
4)The Export Wizard Opens, click OK
5)Click on Advanced Button
6)In the Export Specification window compile the fields you need including
field delimeter and File format
then select Save AS, write the name you oprefere for the specification file
then click OK twice
you are back in Export Wizard click Next and then End
7)Clik on close Button
Change your instruction in
DoCmd.TransferText acExportDelim, "Name of the spec (STEP 6)", "TABLE_X",
YOUR_FileName, True, ""

PS. Sorry if my translations are not correspondent with your english
version, I have an italian version so my translation could be different from
the official one.