Results 1 to 9 of 9

Powerpivot data import with trailing minus

Threaded View

  1. #1
    Forum Contributor
    Join Date
    07-16-2013
    Location
    Houston, Texas
    MS-Off Ver
    Excel 2013
    Posts
    176

    Powerpivot data import with trailing minus

    My text data file have trailing minus (for example 8- instead of -8), when I import them into PowerPivot via OLED/ODBC connection, they become blank. Does anyone knows how to this without VBA?

    This is my connection string:

    Provider=Microsoft.ACE.OLEDB.12.0;Data Source=\\networkname\interface\RPT\;Persist Security Info=false;Extended Properties="Text;HDR=Yes;FMT=TabDelimited";Jet OLEDB:Registry Path=Software\Microsoft\Office\15.0\PowerPivot\ACE\TabDelimited

    Attached is an example of the file.

    Thanks in advance!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Powerpivot data import with trailing minus
    By igoodable in forum Excel General
    Replies: 0
    Last Post: 11-25-2014, 11:39 AM
  2. Import several data sources to PowerPivot
    By Jonathan9 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-20-2014, 09:17 AM
  3. PowerPivot – only import new data from DB
    By MartinCarlsson in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-08-2013, 04:30 AM
  4. Trailing minus
    By mkvassh in forum Excel General
    Replies: 4
    Last Post: 12-03-2008, 08:49 AM
  5. [SOLVED] CHANGE TRAILING MINUS TO BRACKETS OR PRECEEDING MINUS
    By Socal Analyst looking for help in forum Excel General
    Replies: 2
    Last Post: 05-12-2006, 02:20 PM

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