Vexing import issue

aabbey

New Member
Joined
Mar 11, 2011
Messages
1
It's complicated.

I have a client who uses Primavera (P3) project management software. They have exported some data into a .dbf file (because this version of P3 can only export to WK1 and DBF file extensions. Excel and Access are both truncating the data in the first field. If I look at it with a DBF viewer/converter I get the same issue. Open Office is having the same issue.

I opened the file in Notepad. Lo and behold, the information IS there. However, the data is not usable.

If I try to import/open the text file:

Access is seeing it as one enormous row, and says it exceeds the limit.

Excel gives me the text converter wizard, however, I get various issues that all seem to point toward the data in notepad being all mashed together and unusable.

Am I missing something obvious? Or am I attempting the impossible??

I have a manual work around, but for my own peace of mind, I would love to know if I am doing something wrong.
 

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"

Forum statistics

Threads
1,224,599
Messages
6,179,828
Members
452,946
Latest member
JoseDavid

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top