Query to .CSV problem

[JeroenMioch]

Hey guys,

I'm trying to export a query to a .csv file.
This works fine when i use the wizard to do so but i want to automate it.


But when i use code below the export is as .csv but it looks like a plain excel sheet. I need it to be with the comma delimiter.

Im using the export specifications of the wizard (KrpExportspecificatie) as shown below but it looks like access doenst remember what to do.

DoCmd.TransferText acExportDelim, krpExportspecificatie, "qryCSV", "C:\Mylocation\Applications\FOL\KRP\" & Format(Date, "DD-MM-YYYY") & " KRP.csv", False

Any clues or hint as to where im going wrong ?

[June7]

What parameters are provided by the export specification? Have you tried to export without referencing it?

[JeroenMioch]

Yes i did, same effect.
At first i got the feeling i was missing something redicilously simple. But ive looked at it for hours now changing simple things but im getting demotivated now haha.

The export specification file should "remember" wich delimiters i chose, but its just not working.
I tried doing a maketableQuery to see if it would work from a table in stead of a query, to no effect.

[June7]

I just tested export to csv text file and it did save with comma delimiters. I see them when I open the file with a text editor like Notepad. However, also has quote marks around each text value. Didn't expect that.

If you want to provide your db for analysis, follow instructions at bottom of my post.

[JeroenMioch]

Right it seems im a noob (at best)
I should have put krpExportspecificatie in quotation marks like this "krpExportspecificatie"

lol !

Thanks anyway June

[June7]

Sorry I didn't notice that. Don't do many exports. Glad it's solved.

[JeroenMioch]

Dont be sorry, i should have seen it.
But its funny to see how asking for help opens the eyes, even if the one providing help didnt provide the answer.
I have many non programming coworkers here and when im starting to talk to them about code, i find the answer i was looking for.

Psychology.. pff