text import

Hi, I am using the import function to import a text file. But the file is wrapping the text and no matter what I try I can not stop the wrapping. as I could not see anything specific that was causing the wrapping. I am trying to get the information for each record on one row. Any help would be...

I have created VBA import multiple text files into the same sheet and put each file text into one cell but I found a problem with excel limited to 32,767 characters in one cell. Then I split files when characters are over the limit and put it into the next row. Now I have another issue there...

Hi all, I am using the import function to import txt files that always has the same column headers, but I am getting an error message that it can not find the column called Load_Date, but when I open the TXT file I see the header. I do not need to see the load date and I selected remove...

Greetings World, I am using Excel 2010. I am trying to use a Match function to find exact matches to strings in a pdf file that I extracted using text import wizard. The only way that I can get the formula to give me the correct result is to manually retype the Match function's lookup value's...

Help - This is driving me crazy... I have 1.9M records in a csv file, when I initially go into Import Wizard, it tells you that it can not load all the records, but once imported, you can go to another worksheet and do another import and exclude the 1,0485,576, from the first worksheet you just...

Hi, I've never had troubles within importing data into Access via a txt file, but I have one file which is causing me a significant amount of frustration and I'm hoping someone will know the answer!!! ;-) I am trying to import a txt file, but continue to get Import Errors with 'Unparsable...

I am working in Excel 2010 with an imported text file drawn from an older program where headers from a print version are repeated for each page - roughly 3000 headers in one of 15 reports I need to aggregate. I have to keep the headers initiially in order to add data from the headers to the...