Connecting Tech Pros Worldwide Forums | Help | Site Map

how can i read excel data and import into sql using cfm??

Newbie
 
Join Date: Sep 2007
Posts: 5
#1: Aug 1 '08
how can i read excel data and import into sql using cfm???
I have a CFM form for user to import excel file into database and save file in the folder at server location.
I would like to read that excel file and import data into sql database each time the user upload the file and create new record.
Any idea how to solve this problem, every appreciated,
Thanks in advance,

acoder's Avatar
Site Moderator
 
Join Date: Nov 2006
Location: UK
Posts: 14,581
#2: Aug 2 '08

re: how can i read excel data and import into sql using cfm??


See if this thread helps.
Reply