Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have quite a few comma-separated-value (i.e., CSV) files that need to be
converted to XLSX format. Currently, I'm converting each file manually by opening Excel, initiating an import, changing the original data type from Fixed Width to Delimited, de-selecting the Tab delimiter, selecting the Comma delimiter, changing some of the column data formats from General to Text (to prevent incorrect conversion of those columns from text to numeric), and then pressing the Finish button. Is there any way that this process can be automated? Is there any way I could initiate the process from a DOS command-line? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How can I batch convert 97-2003 .xls files to 2007 .xlsx files | Excel Discussion (Misc queries) | |||
.xls files not deleted after conversion to .xlsx; help please | Excel Discussion (Misc queries) | |||
Cannot Open .xlsx files | Excel Discussion (Misc queries) | |||
Help with xlsx files | New Users to Excel | |||
Batch conversion of XP files to 97 files | Excel Discussion (Misc queries) |