Import text file to table

[anishkgt]

Hi,

Was wondering how i can or maybe get a tutorial on how to read data in file(attached) and import data by reading certain amount of characters in a line like A02 and read 30 to 40 characters which has the Name of a passenger and may 20th to 25 has the name of an Airline. Import these data into a table with pre-assigned columns.

[June7]

Review https://www.accessforums.net/import-...ers-42081.html

[anishkgt]

Review https://www.accessforums.net/import-...ers-42081.html

Without any programming background at all, would you please suggest a tutorial which would have these.

[June7]

Don't know any tutorials for importing text file. Only various code examples found on web.

The text file you provide is not a columnar structure and this makes import difficult. If it were a columnar structure, the Access import wizard could easily do the import. What you have requires opening the text file as an object in VBA, reading in one line at a time and parsing the string to look for the data you want.

If you have zero programming knowledge, start learning with:
https://support.office.com/en-US/Art...rs=en-US&ad=US
http://holowczak.com/programming-con...l-programmers/

[orange]

Do you know the structure of the text file? That is do you know where fields start and end?

[anishkgt]

Thanks june for the reply. Will check out that link. Yes orange i have a documentation on the structure of the data.

[orange]

Example on youtube
https://www.youtube.com/watch?v=4_TRNgD0HuY

[anishkgt]

Hi orange,

That video is specific to comma delimitated text file. I know what i need cannot be done with the wizards. It has to be through VB and more over my file as they come are by the extension .MIR

[anishkgt]

June those are just the basics to VB which is not enough for what i need here. Would you be having any other option.

[June7]

Have to start somewhere, crawl before walk.

You need to learn programming concepts, VBA language and syntax, and then structure code specific to your circumstances. If self-teaching is not feasible then I expect courses from local university are available.

If I understood your requirements, could maybe give you code snippet but I don't know what you want to extract from the text file. The description you provided is not clear and I don't know where the data is in the text file.

[anishkgt]

Yes june. You're right. Need to do all those. Well, those data is based on a structure that i could share by mail. Its a pdf file.

[June7]

Share by mail? Why don't you attach to post?