Importing Delimited .dat files into workbook .xlsm

Hi!

Hope all is going well.

I am trying to develop and/or obtain a macro that will import *.dat files into one excel workbook so I can play around with the data.

Data is decent size.

1. Currently I open the .dat file in Notepad, select all, copy within the opened Notepad.
2. I then paste "Use Text Import Wizard", "delimited" already selected, Next, select "comma", deselect "space", and then finish.

I tried to record a macro to do Step 2 but it just pastes all essentally. No comma selection.

The recorded macro came out like this:

Sub DataImport()
'
' DataImport Macro
'

'
Range("A1").Select
ActiveSheet.PasteSpecial Format:="Unicode Text", Link:=False, _
DisplayAsIcon:=False
End Sub

Shouldn't it have something to show it as delimited and the comma/space selection?

Thank you in advance

.
Can you provide a small sample of your .DAT file ? So 25 - 50 rows ?

Originally Posted by Akira29466

Shouldn't it have something to show it as delimited and the comma/space selection?

[Date] - [From Text] - Change File Filter to "ALL(*.*)" - Select .dat file and follow the steps.

RESOLVED

Originally Posted by AlphaFrog

This will prompt you to select a DAT file and then it imports it.

Please Login or Register  to view this content.

AlphaFrog for the win!

This may have trimmed 90% of my time. Worked perfectly.

Akira

great stuff. thanks.