QUERYING FROM EXCEL

[kingjjx]

Hi, I want to query from an excel spreadsheet with COldFusion.
Can anybody tell me how ?

Will it be select * from (filename)

please help ..
thanks

 

[kingjjx]

can someone please tell me how i can use excel as the datasource ???

 

[tleish]

The easiest way is to do it through access... if this isn't an option, the 2nd best thing to do is to save it as a csv file... which option would like an explanation on? - tleish

 

[kingjjx]

you can tell me how to do it through access, that would be fine.

thanks a lot

 

[kingjjx]

tleish, u still there ? need your help dude

 

[tleish]

Sorry...

You can do it through Access 1 of 2 ways, you can link the excel sheet or you can import it. Either way, Access will create a table that you can query against.

If you link the excel sheet, then any edits to the excel sheet will automatically show up in the Access DB... because it is "linked". However I don't recommend this if the CF app is going to hit this table a lot, but it can be a quick solution to small problems. I also don't know if you can update or insert data this with a linked table either.

If you import the table, the perfomance is better, but if you ever change the the excel sheet you just need to re-import the data into excel.

Some references:

Adding Database Tools To Excel Spreadsheets

http://www.vb123.com/toolshed/98docs/excelbe.htm

Data Import/Export

http://www.functionx.com/access/lesson14.htm

- tleish