Export to csv A2007

P

pookie62

Registered User.
Local time
Today, 06:31
Joined
Jan 16, 2005
Messages
47
Hi,
I have a query export to csv, which in A2003 works great.
In A2007 it won't work (on same computer!), I read several posts about the export specifications but have not found the solution yet.
This is line where the export is defined and then exported

Code: 
ExportScore = Application.CurrentProject.Path & "\Score.csv"
DoCmd.TransferText acExportDelim, , "ExportScore", ExportScore, -1

"Error 3441: Text file specification field separator matches decimal separator or text delimiter"
How can it be that on same PC in Access2003 the Export works fine..??:confused::confused:
Who can help me ?
 
Sounds like you have a , as both a seperator and a decimal (or . )

Perhaps A2007 is more strict than A2003, but this should never happen anyways... In a comma seperated file you cannot have a comma as a decimal point.
 
Hi Namliam,
You mean in the regional settings?
Those are:
Decimal ,
Amount of decimals 2
Number groupings symbol .
seperator ;

I live in the Netherlands where these are the way supposed to be.
So this is not it..
Any other thoughts?
 
No I dont mean the regional settings, I mean in your export specification.
 
I got it sorted out..
Created a specification file for every query I had to export (5 queries) and now it's working fine..
Thanks for your help.
 
You can recycle the Specifications if your queries are IDENTICAL in columns and column types...
 
You must log in or register to reply here.

Similar threads

L
Data Change in CSV file after TransferText data export.
2 3
Replies
53
Views
2,940
DickyP
DickyP
S
The text file specification <name> does not exist. You cannot import, export, or link using the specification. (Error 3625)
Replies
12
Views
730
The_Doc_Man
The_Doc_Man
R
Query is fast to run, but very slow to export results
Replies
14
Views
840
Rudolph583
R
C
Cannot export table to csv file from Text Export Wizard
Replies
2
Views
1,181
arnelgp
arnelgp
D
Solved Creating transaction records via OnClick - (Sales Order to Invoice conversion)
Replies
10
Views
557
pbaldy
pbaldy

Users who are viewing this thread

Total: 1 (members: 0, guests: 1)
Back
Top Bottom