> if anyone can help me on this i would appreciate it....
> i was wondering:
> <cfif possible EQ "YES">
> A. i could convert an excel file to sql
> <elseif possible EQ "YES">
> B. i could convert an excel file to access (if at all) then to sql?
> </cfif>
(Answered both in CF-Community and CF-Talk)
If you have access to the SQL Server itself (via Enterprise), then
definitely!
If not, you can create an ODBC connection to either and import it via SQL
Problems with this:
Excel ODBC (and via Access) reads the column type from the top n rows
(around 10 or 15) and then all entries in that column MUST be of that type
or they're treated a NULL - it's either numeric or text
Or, if you have more time and Excel on the server, you could use COM to
speak to the s/sheet and get the exact entries from it
Philip Arnold
Director
Certified ColdFusion Developer
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.
**********************************************************************
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
