Export to csv A2007

[pookie62]

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

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..??
Who can help me ?

 

[namliam]

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.

 

[pookie62]

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?

 

[namliam]

No I dont mean the regional settings, I mean in your export specification.

 

[pookie62]

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.

 

[namliam]

You can recycle the Specifications if your queries are IDENTICAL in columns and column types...

 

[pookie62]

Ok, thnx m8 !