Question How to get a large .dat file into Access

[Kirkuleese]

Hey guys, this is my first post and any help would be very much appreciated.

I have a large .dat file which is run through an Access macro to produce reports. After a recent system change at work the format of the .dat has changed and now includes an additional bit of data which disrupts the macro.

I tried changing the extension of the file from dat to mdb to see if I could remove the additional column in access. I also tried changing it to a csv file as well but the file has a few hundred thousand lines and the csv file cuts most of it out.

Are there any other ways I can open this file in Access to remove this additional column of data?

 

[Kirkuleese]

Hi Pat, thanks for the explanation. My next question would be could I use the TransferText function in VBA in Access?