> B. i could convert an excel file to access (if at all) then to sql?
I have converted excel files into CSV (comma separated values) and then
imported those CSVs in Access. And then used ColdFusion to move the data
from Access to MSSQL.
In Excel: File -> Save As -> CSV
In Access: File -> Get External Data -> Import, select a CSV file and
follow the wizard.
In CF: Select fields from Access datasource, loop over the query results
and insert into MSSQL.
Erki
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
