Importing Tab files

  • Thread starter Thread starter Fred Murray
  • Start date Start date
F

Fred Murray

Hello,

Here's some odd behavior from Excel. I need to import a tab file with the
following two requirements:

req 1. Newlines within quotation marks are preserved as part of the record
req 2. All fields are imported as text

Now, if I do file->open and go through the import wizard, req 2 is met because
I can select all fields and set them to text. However, it splits records
at newlines within quotation marks no matter what I try.

If, on the other hand, I drag and drop the tab file onto Excel, it preserves
newlines, but there's no way (as far as I can tell) to force it to input
as text. Thus, "1/5" ends up as "Jan 5".

Thanks for any help.
 
This might not be useful:

Is there anyway you can edit the text file to change those LFCR's to something
else (some unique character).

then import your data and edit|replace that unique character with alt-enters?
(hit an hold the alt and type 0010 from the numeric keypad)????

or maybe you could parse the data yourself:
File Access with Visual Basic® for Applications
http://support.microsoft.com/support/excel/content/fileio/fileio.asp


===

And you can specify Text for that 1/5 field in the import wizard if you end up
using that.
 
Back
Top