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!
Bookmarks