D
Denise
How can I get a .csv file using transfer text?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
S
Steve Schapel
Denise,
Have you tried setting the File Name argument of the TransferText macro
action to show the name of the file with a .csv extension? Are you using
Export Delimited for the Transfer Type argument?
Have you tried setting the File Name argument of the TransferText macro
action to show the name of the file with a .csv extension? Are you using
Export Delimited for the Transfer Type argument?
D
Denise
Steve Schapel said:Denise,
Have you tried setting the File Name argument of the TransferText macro
action to show the name of the file with a .csv extension? Are you using
Export Delimited for the Transfer Type argument?
D
Denise
Yes - I tried .csv first. However, it still looks like an excel file and not
a comma delimited.
a comma delimited.
K
Ken Snell \(MVP\)
When you say "looks like an excel file", do you mean the file icon in
Windows Explorer looks kinda like the EXCEL icon? If yes, that is because
your computer has the ".csv" file type associated with EXCEL for opening the
file. It is still just a comma-delimited text file that can be opened with
Notepad or Wordpad.
Windows Explorer looks kinda like the EXCEL icon? If yes, that is because
your computer has the ".csv" file type associated with EXCEL for opening the
file. It is still just a comma-delimited text file that can be opened with
Notepad or Wordpad.
D
Denise
Ken,
If I say Output Format = Text File and Output File = xxx.csv; The outcome in
notepad = Fields surrounded with dashes
If I say Output Format = Ms Excel and Output File = xxx.csv; The outcome in
notepad = No ledgeable charactors (all little squares and such)
If I say Output Format = Text File and Output File = xxx.csv; The outcome in
notepad = Fields surrounded with dashes
If I say Output Format = Ms Excel and Output File = xxx.csv; The outcome in
notepad = No ledgeable charactors (all little squares and such)
K
Ken Snell \(MVP\)
Don't export a csv file using TransferText with a format of MS EXCEL. Use
Text File.
--
Ken Snell
<MS ACCESS MVP>
http://www.accessmvp.com/KDSnell/
Text File.
--
Ken Snell
<MS ACCESS MVP>
http://www.accessmvp.com/KDSnell/
D
Denise
Ken Snell (MVP) said:Don't export a csv file using TransferText with a format of MS EXCEL. Use
Text File.
--
Ken Snell
<MS ACCESS MVP>
http://www.accessmvp.com/KDSnell/
S
Steve Schapel
Denise,
You have lost me here. There is no Output Format argument for the
TransferText macro action.
You have lost me here. There is no Output Format argument for the
TransferText macro action.
K
Ken Snell \(MVP\)
I think she was using the OutputTo action in a macro, Steve.
S
Steve Schapel
Hmmm... that's certainly a possibility, Ken. ;-)
D
Denise
Ken is correct - I was using the "output to" after speaking with you IKen Snell (MVP) said:I think she was using the OutputTo action in a macro, Steve.
--
Ken Snell
<MS ACCESS MVP>
http://www.accessmvp.com/KDSnell/
Steve
changed it to TransferText using a specification and it worked. Sorry about
confusing you; I tried so many ways that I did not realize I was using the
"Output to".
Thanks Denise