Hi...

I'm wondering if it's possible to export an excel file to a csv file via
script. I have data in excel that I need to import into a SQL Server
database, but importing the excel spreadsheet results in missing data or
values that are assigned to null when they have a value in the spreadsheet.
If I convert the excel spreadsheet to a csv and import the csv, it works fine.

I know the users of the spreadsheet can export/save as a csv file, I'd
rather automate this process rather than relying on them to actually do this
themselves. Is this at all possible?
--
Chris Burke