How to extract Microsoft Excel workbook data in a query

1143015 pts.
Tags:
Microsoft Excel
I'm currently working on an Excel workbook that contains over a million rows and can't be turned into a worksheet unfortunately. Is there a way I could extract all of this data in a query? Can I extract it to a CSV file? I can turn the data into a pivot table if that helps. Thank you.
0

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • ToddN2000
    Your question is a little confusing. What are you looking to do with the data? If your data is in Excel currently and you cannot add any additional data it may be best to store it elsewhere. Where is the data currently coming from? You may need to export this to a database system if you see this data collection continuing to grow. You may need to put it in an Access Database or if this is connected to a mainframe or mid-range system like an i-Series then you can export the data to that system. More specific details are need to give a better answer.
    132,840 pointsBadges:
    report
  • Subhendu Sen
    Yes, you can export data from Excel to MS Access or import date from Excel to MS Access. Please link here for help from Microsoft: https://support.office.com/en-us/article/exchange-copy-import-export-data-between-excel-and-access-409c27cc-c69d-461d-a74c-35392a68ed53

    Or try to export Excel file as PDF format.

    139,010 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: