+ Reply to Thread
Results 1 to 6 of 6

Pivot table via external data sourse (cvs)

  1. #1
    Registered User
    Join Date
    09-16-2008
    Location
    USA
    Posts
    4

    Pivot table via external data sourse (cvs)

    Here the Issue with no answer so far:

    I have several large CSV files I need to work with. File source is Oracle (10g) Query Exports to Comma Separated Values data file.
    I need Vlookup capability and Pivot Table functionality when working with these files. I receive new data files each business day.

    Rather than open each file, convert to Excel 2007 xlsx format, set up pivot tables and add VLookups each time I get a new file (daily), I want to create a pivot table that connects to the raw CSV file via Data Connections. When I try to connect via Excel 2007 Data Connections I am receiving a message that I can't create a pivot table using data in a csv format.

    Is this correct? Or am I missing an Add-In? Any suggestions on how to do this?

    Attached is a sample data file (limited to the first 100 records) - however, the data is in xls format which makes the operation possible.
    It doesn't work with the csv file.
    the exact message I get reads:
    The type of connection selected cannot be used to create a Pivot Table.

    Thanks for your insight.
    joanna.
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    02-18-2006
    Location
    Vancouver, WA - USA
    MS-Off Ver
    All components of Office 2007
    Posts
    31

    Oracle Response

    Are you using a command to have those files exported from your query? Can you paste that code in this post string? I know it is possible to export in Excel 4 format which would solve your issue, but not sure what software you are using to run your query and export the data.

    Thanks.
    __________________

    Best Regards,
    Jim
    Analyst

    Analyzing life, one day at a time!

    Forum Rules

    Click on the scales in the upper right corner of my post if you like what I suggested. It helps with my reputation. Thanks.

    My hidden rantings page - click here

  3. #3
    Registered User
    Join Date
    09-16-2008
    Location
    USA
    Posts
    4

    Re: Oracle Response

    Jimmy,

    The export of the files from Oracle needs to be done as txt or csv because of the size of the files. It takes too much time to export them as xls.
    I already checked that having files in xls format works but not as csv..

    Is there any way I can get it to work having only csv files?

    Please advise.
    joanna

  4. #4
    Registered User
    Join Date
    02-18-2006
    Location
    Vancouver, WA - USA
    MS-Off Ver
    All components of Office 2007
    Posts
    31
    Not that I am aware of. I think your best bet is to right click of the csv, select edit, then save a xls. Then do your pivot point to that file. Should work then. It is fairly fast to do and you don't have to go through the import from text process into an existing spreadsheet.

    Someone may know differently though . Sorry.

  5. #5
    Registered User
    Join Date
    09-16-2008
    Location
    USA
    Posts
    4

    Re

    Thanks, Jimmy - but I have already tried to change the name, too
    It doesn't work this way either.
    I'll try again a few times, though.
    thank you for you replies.
    joanna.

  6. #6
    Registered User
    Join Date
    02-18-2006
    Location
    Vancouver, WA - USA
    MS-Off Ver
    All components of Office 2007
    Posts
    31
    I was a noob on the CSV thing. You can't save as XLS from CSV format using Edit. I tested this on one of my files that was CSV. I opened it instead, saved immediately as XLS, and was able to pull it in externally with a pivot point on a different excel file. I know that does not help your point, but excel won't pull in pivot data from a csv or text file. Sorry again. GL!

    Jim

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Pivot Table, Calculated Item.... No Data, still creates a row
    By Oscar in forum Excel Charting & Pivots
    Replies: 16
    Last Post: 07-09-2020, 11:51 PM
  2. pivot table to ingore formulas in data table
    By nicko54 in forum Excel General
    Replies: 0
    Last Post: 07-10-2008, 10:30 AM
  3. Pivot Table VBA - Data Field - Original (source) field name
    By hbgpausa0 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-22-2008, 10:25 AM
  4. Adding to Pivot Table data range
    By spack in forum Excel General
    Replies: 1
    Last Post: 04-05-2007, 01:04 PM
  5. How to edit the Pivot Table data range?
    By smartcard in forum Excel General
    Replies: 1
    Last Post: 12-26-2006, 04:57 AM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1