Post reply

sql queries on excel sheet???

  • January 19, 2009 at 11:29 pm

    #130079

    hi all,

    is it possible to use sql queries on excel sheet?

    for example select * from sheet_name..

    if yes means can you give me a model query

  • January 20, 2009 at 4:46 am

    #929599

    Yes, you can. Just add the sign "$" after the sheet name in the query, for e.g.

    SELECT * FROM [Customer$]

    WHERE "Customer" is the name of the sheet...

    --Ramesh

  • January 20, 2009 at 6:22 am

    #929676

    thanks ramesh for your reply

  • January 21, 2009 at 1:05 pm

    #930657

    Beware though. Don't use it without reservation. Excel is not a DB. There plenty of ways to get bit by this by relying on it for production.

  • January 23, 2009 at 3:31 am

    #931710

    Now this I did't know. I very knew you could do this!

    But I'm quite sure that this should be done with great care as well!

  • January 23, 2009 at 10:03 am

    #931930

    It can be great for batchloading data. Remember that for data it may act like an sql db, it isn't. No xactions, isolation or concurrency.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply