Transfer spreadsheet statement using .csv file 1

[fogal]

Can you use the transfer spreadsheet to save a file as a .CSV file. If so, what spreadsheet type to put in the code???????

Thanks in advance

 

[WildHare]

Sure can. It's really a function of the export process more than anything else..when you use the TransferText method with the acExportDelim option, Access will automatically comma-separate values, and quote-enclose any with embedded spaces.

.TransferText acExportDelim, , {some table name},"C:\MYSTUFF.CSV"

The CSV style is nothing special - you can even save a file as "FatFatFanny.FOO" , and it will be comma-separated. Excel might not see it, but it will indeed be Comma Separated..

Jim






If at first you don't succeed, skydiving probably isn't for you!
Another free Access forum:

http://www.forumco.com/jmhare

More Access stuff at

http://www.jmhare.com/wildhare.htm