Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2010

    Unanswered: Excel as Databse/Table


    I have large amount of data in Excel and I need to prepare a specific report. Currently I use lot of formulas to get the report. Now since the data has increased, my system gets restarted (without creating my report).

    I would like to know, how can Excel act as a Table so that using SQLs data can be retrieved.

    Suppose I have Data in Sheet1 of MS Excel, In background using VBA is it possible to query the data with common SQLs?

    If this option is not good, please suggest me how can this be done.
    Will copying data to access and querying there and writing report in excel is good option?

    Please advice.


  2. #2
    Join Date
    Sep 2011

    Excel as Databse/Table

    In Excel large amount of data,I need to prepared repot.i have face excel printing problems.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts