INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

TransferText Error

TransferText Error

(OP)
Hi,

Wondering if someone could help me out with the TransferText function.
After executing the code below, I get the below error message:

Text file specification field separator matches decimal separator or text delimiter.

Here'e the code I'm using:
DoCmd.TransferText acExportDelim, , "CSVExport", "C:\CsvExport.csv"

The CSVExport Table that I'd like to export does not contain any autonumeric/unique Id's and or fields other than text's.


Any ideas would be appreciated.
Thanks,






RE: TransferText Error

I think that you place too much faith in defaults.
ALWAYS better to explicitly define exactly how you want a SPECIFIC file to be imported / exported.
If on the first attempt you experience problems; even if it's a one-off process, it will generally always reduce time in doing things like this.

Define an import spec and this will cut issues down by 99%.

This seems a definitive step-by-step of how to do that:


(Name the spec logically - so that you 'know' what it is to be used for in future).

The alternative is to analyse exactly what is incorrect in this file (and every other file where you get this error), where the possibilities are infinite.

ATB,

Darrylle

Never argue with an idiot, he'll bring you down to his level - then beat you with experience.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close