> I am interested in getting data from excel format into MSSQL 7
> using coldfusion.
>
> Anyone already done it?
I do it a rather convoluted way, but since the client is uploading the data,
it has to be rather strict...
The column names have to stay the same, and be in existance (unless you do
select * and then use isDefined() through the list)
The Excel ODBC driver can't be released by SQL code, so I made an Access
database with just a link table to the Excel file - this required the exact
location of the file to be known
Once this is set-up, then you can use it as any normal ODBC datasource.
One BIG warning though, the Excel ODBC driver is rather strange, once it
grabs a column, it works out whether it should be Text or Numeric by
sampling the top few rows, the column is then fixed in that format, so any
of the alternate format will be treated as NULL
This means that if the field contains telephone numbers, any without spaces
will be numeric and those with spaces will be textual. A real dog, but as
long as the format is confirmed, then it will work fine.
Philip Arnold
ASP Multimedia Limited
T: +44 (0)20 8680 1133
"Websites for the real world"
**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**********************************************************************
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
