|
Home > Archive > microsoft.public.sqlserver.server > November 2002 > Converting XLS to CSV
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Converting XLS to CSV
|
|
| Steven 2002-11-10, 6:23 pm |
| Hi,
I was wondering whether it was possible to convert an Excel
spreadsheet to a CSV file with having Microsoft Excel. I have created
the script to do this but I need Excel for it to work.
I have also tried this using a DTS in sql server but ran into the the
datatype problem. From what a read each column in the spreadsheet
MUST be either text or number but I need both.
Any solution would be much appreciated.
Thanks.
| |
| Paul Randall 2002-11-11, 12:23 am |
| Hi, Steven
You might try lurking in the ADO newsgroups. I think I've seen references to getting into Excel files with ADO and Jet. VB answers
should convert to VBScript pretty easily.
Some URLs:
http://support.microsoft.com/defaul...B;EN-US;257819&
http://msdn.microsoft.com/library/d...n_adorosest.asp
There is another URL on MSDN that talks about issues of converting VBA to VBScript, but I can't find the URL right now.
-Paul Randall
"Steven" <steven.chang@au.bosch.com> wrote in message news:c81d7162.0211101551.708e0b57@posting.google.com...
> Hi,
>
> I was wondering whether it was possible to convert an Excel
> spreadsheet to a CSV file with having Microsoft Excel. I have created
> the script to do this but I need Excel for it to work.
>
> I have also tried this using a DTS in sql server but ran into the the
> datatype problem. From what a read each column in the spreadsheet
> MUST be either text or number but I need both.
>
> Any solution would be much appreciated.
>
> Thanks.
| |
| Steven 2002-11-11, 4:23 pm |
| Thanks Paul.
I'll give it a try.
Steven.
"Paul Randall" <paulr901@cableone.net> wrote in message news:<uB7ufkUiCHA.2672@tkmsftngp09>...
> Hi, Steven
> You might try lurking in the ADO newsgroups. I think I've seen references to getting into Excel files with ADO and Jet. VB answers
> should convert to VBScript pretty easily.
> Some URLs:
> http://support.microsoft.com/defaul...B;EN-US;257819&
> http://msdn.microsoft.com/library/d...n_adorosest.asp
>
> There is another URL on MSDN that talks about issues of converting VBA to VBScript, but I can't find the URL right now.
>
> -Paul Randall
>
> "Steven" <steven.chang@au.bosch.com> wrote in message news:c81d7162.0211101551.708e0b57@posting.google.com...
> > Hi,
> >
> > I was wondering whether it was possible to convert an Excel
> > spreadsheet to a CSV file with having Microsoft Excel. I have created
> > the script to do this but I need Excel for it to work.
> >
> > I have also tried this using a DTS in sql server but ran into the the
> > datatype problem. From what a read each column in the spreadsheet
> > MUST be either text or number but I need both.
> >
> > Any solution would be much appreciated.
> >
> > Thanks.
|
|
|
|
|