Convert Text Doc to Excel

[LynneM1]

Hi,
I need some help from experts.

We received several sets of data as some sort of Notepad format. I am unfamiliar with this sort of data. How can you convert this into the excel format? I'm not even sure what to call it. The data is sloping from upper left to lower right.

 

[Mike Blackman]

Hi Lynn,

From within Excel you could try;

Data - Import External Data - Import Data

Then Navigate to the file in question and see how Excel pulls it through, its difficult without actually seeing the file, is it delimited in anyway ie. With Semi-Colon's or Tabs, etc.?

 

[LynneM1]

I feel so ignorant. Yes, I tried to import into Access and have the same Text Import Wizard. The file is an ASCII formatted file, so whihc items do I select in the Wizard?

 

[Mike Blackman]

Hi Lynn,

Did you try to import into Excel or just Access?

 

[LynneM1]

Both.