Hi,
I run a make-table query which saves the data I require to a table called "tempcsv".
I can manually export this to a csv file - however I have tried two different methods to do this automatically, however both have errors - if anyone could help me to solve either one then I would be very thankful.
The first method I tried was a Macro using the Outputto method, here is what the macro looks like:
(Outputto)
Object Type: Table
Object Name: tempcsv
Output Format: MS-DOS Text (*.txt)
Output File: C:\Documents and Settings\Dean Rowe\Desktop\tempcsv
Autostart: No
Template File:
However if I open the file using notepad it comes out like this:
---------------------------------------------------------------------------------
| Total Selling inc | Customer Name | Customer Address | Customer Postcode |
---------------------------------------------------------------------------------
| œ366.60 | Test Name2 | la la land | NN4 6AF |
---------------------------------------------------------------------------------
and if I open it using excel it has a similar appearance.
I've tried changing the output format to: Microsoft Excel (*.xls)
If I open it in notepad then it appears like this:
õÿ ôÀ à õÿ ôÀ à õÿ ôÀ à õÿ ôÀ à õÿ ôÀ à õÿ ôÀ à À à + õÿ øÀ à ) õÿ øÀ à , õÿ øÀ à * õÿ øÀ à õÿ øÀ à !P à "x AIà "x @,I, à ¦ +| @,I, à
and if I open it in excel it has the field headings above the data, which I dont want to appear.
So I tried a different Macro, using the TransferText option:
(TransferText)
Transfer Type: Export Delimited
Specification Name: temp csv export {I created this when I successfully exported the table manually}
Table Name: tempcsv
File Name: C:\Documents and Settings\Dean Rowe\Desktop\tempcsv
Has Field Names: No
HTML Table Name:
Code Page:
However when I run the macro, the following error occurs:
"Cannot Update. Database or Object is read-only"
If anyone could help me or provide any advice then I'd appreciate it very much, I can't think how to get around this problem.
In case there is any confusion, I'm trying to output a table which contains 1 row of four fields so the outputted file looks like this:
[Field One],[Field Two],[Field Three],[Field Four]
Thanks again
Dean Rowe
I run a make-table query which saves the data I require to a table called "tempcsv".
I can manually export this to a csv file - however I have tried two different methods to do this automatically, however both have errors - if anyone could help me to solve either one then I would be very thankful.
The first method I tried was a Macro using the Outputto method, here is what the macro looks like:
(Outputto)
Object Type: Table
Object Name: tempcsv
Output Format: MS-DOS Text (*.txt)
Output File: C:\Documents and Settings\Dean Rowe\Desktop\tempcsv
Autostart: No
Template File:
However if I open the file using notepad it comes out like this:
---------------------------------------------------------------------------------
| Total Selling inc | Customer Name | Customer Address | Customer Postcode |
---------------------------------------------------------------------------------
| œ366.60 | Test Name2 | la la land | NN4 6AF |
---------------------------------------------------------------------------------
and if I open it using excel it has a similar appearance.
I've tried changing the output format to: Microsoft Excel (*.xls)
If I open it in notepad then it appears like this:
õÿ ôÀ à õÿ ôÀ à õÿ ôÀ à õÿ ôÀ à õÿ ôÀ à õÿ ôÀ à À à + õÿ øÀ à ) õÿ øÀ à , õÿ øÀ à * õÿ øÀ à õÿ øÀ à !P à "x AIà "x @,I, à ¦ +| @,I, à
and if I open it in excel it has the field headings above the data, which I dont want to appear.
So I tried a different Macro, using the TransferText option:
(TransferText)
Transfer Type: Export Delimited
Specification Name: temp csv export {I created this when I successfully exported the table manually}
Table Name: tempcsv
File Name: C:\Documents and Settings\Dean Rowe\Desktop\tempcsv
Has Field Names: No
HTML Table Name:
Code Page:
However when I run the macro, the following error occurs:
"Cannot Update. Database or Object is read-only"
If anyone could help me or provide any advice then I'd appreciate it very much, I can't think how to get around this problem.
In case there is any confusion, I'm trying to output a table which contains 1 row of four fields so the outputted file looks like this:
[Field One],[Field Two],[Field Three],[Field Four]
Thanks again
Dean Rowe
