Data import from a Notepad

Closed
mahfuz19 Posts 4 Registration date Sunday November 10, 2013 Status Member Last seen February 16, 2014 - Feb 16, 2014 at 10:39 AM
 Blocked Profile - Feb 16, 2014 at 11:33 AM
Hello everybody. Hope you are doing well. please help me in the following situation.

Suppose i have a notepad file where there are some company record. Under each company there are some field say 20a,21b,..and so on. Now i need to took only value in field 21b against each company in Excel to make a database.

Thank you in advance.

Regards
Mahfuz
Related:

1 response

Blocked Profile
Feb 16, 2014 at 11:33 AM
Ok, well do you need the row of 21, or the column of b? Because in excel terms, each value in b21 is really only one value.


As far as importing data, delimit it.

As far as importing it, do the same into your database, as you can import text files into databases, too. Cut out the middle man.

0