S
Scot
I need to be able to take an excel file, and
convert that file into a CSV file without
going into excel. I want to do it in a batch format.
The main reason for this is a problem that shows
up in SQLServer. When you try and take an xcel file
and import the data into SQLServer using DTS,
the Driver looks at the majority of the data in a column.
If it finds more numbers than character data, it loads
that data as numbers. All the character data is imported
as NULLs... which doesn't help. I lose some of my data.
SQL Server will import the data properly using a CSV file
convert that file into a CSV file without
going into excel. I want to do it in a batch format.
The main reason for this is a problem that shows
up in SQLServer. When you try and take an xcel file
and import the data into SQLServer using DTS,
the Driver looks at the majority of the data in a column.
If it finds more numbers than character data, it loads
that data as numbers. All the character data is imported
as NULLs... which doesn't help. I lose some of my data.
SQL Server will import the data properly using a CSV file