freelanceprogrammers.org Forum Index » Cold Fusion
excel to coldfusion
Joined: 25 Apr 2005
Posts: 6
excel to coldfusion
Hi, i don`t have any idea to work this thing. Can anybody help me out?
I`m using mysql and user wants to upload an excel file and it will
automatically export to mysql database through web(coldfusion of
course).The excel field will also be standardize too.Got any idea?
Joined: 05 Apr 2005
Posts: 37
excel to coldfusion
The way I do it, is set a generic file (like the excel file) as a
datasource (Excel-type). Then when the user uploads the file, use
Cold Fusion to rename the file and overwrite the existing
datasource. Then, I can query the datasource as an excel file (the
sheet tab is referenced instead of tablename).
So, for example,
SELECT * From [Sheet1$] WHERE ID=5
Otherwise, it works pretty much the same. The first row of the
table should be the column headers. So, for example, ID, DESC,
whatever. You refer to them just like table fields.
tablename.fieldname
Do you think that would work for you?
Jen
--- In cold_fusion@yahoogroups.com, "arinpsycho" <arinpsycho@y...>
wrote:
> Hi, i don`t have any idea to work this thing. Can anybody help me
out?
> I`m using mysql and user wants to upload an excel file and it will
> automatically export to mysql database through web(coldfusion of
> course).The excel field will also be standardize too.Got any idea?
Joined: 25 Apr 2005
Posts: 6
excel to coldfusion
hmmm...that should work. But i`m still looking to work with
mysql.But if no one can have the solution i`ll give it a try to your
method, or even try in VB
--- In cold_fusion@yahoogroups.com, "Jennifer" <chrystalheart@y...>
wrote:
> The way I do it, is set a generic file (like the excel file) as a
> datasource (Excel-type). Then when the user uploads the file, use
> Cold Fusion to rename the file and overwrite the existing
> datasource. Then, I can query the datasource as an excel file (the
> sheet tab is referenced instead of tablename).
>
> So, for example,
>
> SELECT * From [Sheet1$] WHERE ID=5
>
> Otherwise, it works pretty much the same. The first row of the
> table should be the column headers. So, for example, ID, DESC,
> whatever. You refer to them just like table fields.
> tablename.fieldname
>
> Do you think that would work for you?
>
> Jen
>
> --- In cold_fusion@yahoogroups.com, "arinpsycho" <arinpsycho@y...>
> wrote:
> > Hi, i don`t have any idea to work this thing. Can anybody help
me
> out?
> > I`m using mysql and user wants to upload an excel file and it
will
> > automatically export to mysql database through web(coldfusion of
> > course).The excel field will also be standardize too.Got any
idea?
All times are GMT
Page 1 of 1
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
Freelace Website Designer - Customer web design and software building.
Booking Calendar - reservation calendar script
Land Surveying - total station instruments and equipments
China Wholesale - Electronics Products
Character Studio - Tutorials and Help
Booking Calendar - reservation calendar script
Land Surveying - total station instruments and equipments
China Wholesale - Electronics Products
Character Studio - Tutorials and Help