Import txt file (1 Viewer)

[bhelmy]

i have text file want to import but need to ignore first row and make second row contains field names

 

[namliam]

You will have to create your own import for this. Or atleast manipulate your file from code...

Check out FileSystemObject (FSO) here: https://docs.microsoft.com/en-us/of...e/user-interface-help/filesystemobject-object

See if you can figure it from there, if not come back with any questions

 

[isladogs]

Another approach is to save as an Excel file then import a specified range starting at row 2

 

[bhelmy]

You will have to create your own import for this. Or atleast manipulate your file from code...

Check out FileSystemObject (FSO) here: https://docs.microsoft.com/en-us/of...e/user-interface-help/filesystemobject-object

See if you can figure it from there, if not come back with any questions

i cant made it , Please help

 

[bastanu]

Have a look:

Delete first line from txt file - Visual Basic (Classic) - Tek-Tips

Hi, I'd like to delete the first line of a text file from the click of a button. Hope someone can help Regards, Steve K

www.tek-tips.com

Google Sites: Sign-in

Access Google Sites with a personal Google account or Google Workspace account (for business use).

sites.google.com

Solved: VBA - Read "txt" files in a folder and delete first line according to a criteria | Experts Exchange

Find answers to VBA - Read txt files in a folder and delete first line according to a criteria from the expert community at Experts Exchange

www.experts-exchange.com

Cheers,
Vlad

 

[namliam]

i cant made it , Please help

What have you tried, what are your troubles