Export csv file different ?

[Oded Dror]

Hi there,

I'm using MS Access 2002 and Northwind database.

When I use Macro
Output To command
Object Type: Table
Object Name: Shippers
Output Format: Text File (*.txt)
Output File: C:\Shippers.csv
Auto Start: No
Template File : blanc
Encoding: blanc
Save and Run
I'm getting this format

--------------------------------------------------------------
| Shipper ID | Company Name | Phone |
--------------------------------------------------------------
| 1 | Speedy Express | (503) 555-9831 |
--------------------------------------------------------------
| 2 | United Package | (503) 555-3199 |
--------------------------------------------------------------
| 3 | Federal Shipping | (503) 555-9931 |
--------------------------------------------------------------


When I Right click on qryShippers and Export
File Name: qryShippers
Save As Type: Text(*.txt,*.csv,*.tab,*.asc)
Click Export: Delimited Comma "
I'm getting this format

1 Speedy Express (503) 555-9831
2 United Package (503) 555-3199
3 Federal Shipping (503) 555-9931


My questions is:
1.Why is that ?
2. How to create a Macro that will give my the format like Export qry ?

Thanks,

Oded Dror

Email: (e-mail address removed)

 

[Steve Schapel]

Oded,

Try using the TransferText action in your macro, instead of OutputTo.