How to split text data from table

[SachAccess]

Hi @Gasman I agree with you.
Separate modules are just for the moment. Till I was sure that the step I am trying to perform is getting completed without any issues.
That is why broke into small parts for the time being.

Yes, will rename button names more meaningful.
When I import the table it does not have auto number field.
The code @moke123 has provided me has auto number field hence I created that in my table too to get the result.
Thanks.

 

[Gasman]

We have no idea what you are doing with this data, or even if an autonumber fields are required.
As I mentioned in the other thread. Take 5 and work out the steps, and build one at a time.

 

[moke123]

If your data is going to have different datatypes you may have to use a staging table to import the text and then write it to your final table converting the datatypes as needed.

 

[Gasman]

Why not just import into excel if that is where it is going to end up?
Record a macro when you import your sample file.

Mucking around with 1M rows is going to take time anyway you do it, I would have thought?

 

[SachAccess]

Hi @Gasman , thanks for the help. Excel would have been really good choice for me.
But data is exceeding more than 1 million rows hence I am trying with Access.

 

[Gasman]

Excel specifications and limits - Microsoft Support

In Excel 2010, the maximum worksheet size is 1,048,576 rows by 16,384 columns. In this article, find all workbook, worksheet, and feature specifications and limits.

support.microsoft.com

 

[SachAccess]

Got something on stackoverflow regarding Excel. Hopefully I should be able to crack it.
Thanks a lot everyone for the constant help. Have a nice weekend.

PS - If Excel does not work then I will again seek help here.