Text columns exporting to currency columns

[Marc]

I have never seen this before. I have verified and double checked the data
type in my Excel spreadsheet which is a text column and in Access it is also
a text column. Importing the data from Excel to Access is ok, it's when I
export to a fixed width text file is when it gets messed up. I can't figure
out why the data in this particular item is exporting as a currency data type
when it's clearly a text data type. Any ideas?

 

[Jeff Boyce]

Marc

Are they numbers (i.e., digits)?

In your query (I'm assuming you are using a query to get the data to
export), are you explicitly coercing the field(s) to be text, using the
CStr() function?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Marc]

They could be both numbers or letters. I've tried entering the just letters
and when I export it from the query it gives me a message that it's a
datatype violation. I guess I don't understand because I have other columns
like that and they export fine.

 

[Marc]

I forgot to add I'm not using the cstr function for that column in my query.

 

[Jeff Boyce]

Marc

If you leave it to Access to decide, it may not get it right.

What happens if you coerce the field using CStr()?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Marc]

Found out my saved specification was corruppted. I had to delete and make a
new one. After that I didn't have any problems. Thanks for the help!