C
Chris B
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?
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?