exporting quote csv

[mcb999]

In access 2007 im running a query and need to export the fields with quotes around them.

select productName, productPrice
from Products

needs to come out as:

"product1","price1"
"product2","price2"

etc...

Whats the way to do this? I know this is probably pretty basic but so am i right now.
Thanks

 

[mcb999]

Basically what im trying to do is take all my data from this table and export it into a csv but each field needs to be surrounded by quotes. Whats the best way of doing this?

Thanks,
Micah...

 

[jadams0173]

I have done similar making a comma delimited text file with all values wrapped in double quotes. I would suggest (maybe no the best suggestion) opening a recordset and export the recordset to excel and wrap each field in "data" using Chr$(34).

I'm not sure how excel is going to respond to this.



I tried to have patience but it took to long! -DW

 

[mcb999]

Originally I had the data in excel. Im not sure how to take existing data in there and appending a quote to the front and end of each field. Could you explain this please?

Thanks

 

[jadams0173]

So are you taking the data out of an Access table now or is it still in excel?

I tried to have patience but it took to long! -DW

 

[mcb999]

either way to get it to work.