How can I resolve error 3438?

[GreenBelt74]

Trying to export a table to .ansi formatted file. Keep getting error 3438:
The data being exported does not match the format described in the Schema.ini
file.

Any ideas?

 

[Douglas J. Steele]

Do you think that the file does match what it says in the Schema.ini file?

 

[GreenBelt74]

How can I see the Schema.ini file?

Do you think that the file does match what it says in the Schema.ini file?

 

[Douglas J. Steele]

Look in the same folder as the text file is in.

If you can't find one there, what steps are you following when trying to
export the data.

 

[GreenBelt74]

The text file doesn't exist yet; that's what I'm trying to create from a
table I have. The steps I am following:

- created a macro where only action is TransferText (this is how I've done
this succesfully in the past).
- in section on bottom of macro design view:
- Transfer Type: Export Fixed Width
- Spec Name: I created a fixed width import spec that matches the table I
am trying to export (UploadPatient Exp Spec)
- Table Name: The name of the table (File2OP)
- File Name: The folder location I would like the .ansi file to go and
the name I would like to call it (server/folder/location/filename.ansi)
- Has Field Names: Yes (Field names in Spec match the table)

I run the macro and get the error message. I have another table in this DB
that I also needed to make an .ansi file and everything worked fine. I have
another macro and another ExportSpec that worked great.

Thanks for your help Doug!

 

[Douglas J. Steele]

For one thing, unless you've changed your Registry as described in
http://support.microsoft.com/?id=245407 I don't believe you can export to a
file with the extension of .ansi (Don't worry that the KB article only
mentions Access 2000 and talks about importing. It applies to all versions
since Access 97, and it applies both ways)

See whether changing your file extension makes a difference.

 

[GreenBelt74]

I just realized one of my fieldnames is Patient_ID and my export spec
fieldname is Patient _ID. There was a space in front of that underscore. I
will now stab my eye with a pen.

Thanks for all of your help...Cort