HI,
Right Click .txt file and open with excel just try it
On Mon, Apr 5, 2010 at 2:37 PM, Mahesh wrote:
> Dear All,
>
> Need ur advise...
>
> I got around 20 text files in a day,which had 13 to 15 columns separated by
> "|" this sign. each file contains around 15 lacs or more line items.
>
Sub ImportData()
Dim I As Long
Dim Filename As String
I = 1
Filename = "C:\Documents and Settings\akoul\Desktop\my
desktop\TESTSPLIT.txt"
Open Filename For Input As #1
Do While (Not EOF(1))
Input #1, Streng
Cells(I, 1) = Split(Streng)
I = I + 1
If I = 1048575 The
Import the text file to Access.
Then based on the criteria, Import the records to Excel.
thanks and Regards,
Anand
On Mon, Apr 5, 2010 at 2:37 PM, Mahesh wrote:
> Dear All,
>
> Need ur advise...
>
> I got around 20 text files in a day,which had 13 to 15 columns separated by
> "|" this sign.
Hello Dear,
Here is the attached macro for your problem.
Here string are picked after tab or new line. u can make change
if string are separated by any special character.
Hope it Will Help
Happy to Help
:)
Shyam
On Mon, Apr 5, 2010 at 5:06 PM, rf1234 rf1234 wrote:
> Hello Dear
Hello Dear,
This problem is alredy discussed in previous post.
try to find out importing txt from notepad to excel.
Hope it Will Help
Happy to Help
:)
Shyam
On Mon, Apr 5, 2010 at 2:37 PM, Mahesh wrote:
> Dear All,
>
> Need ur advise...
>
> I got around 20 text files in a day,which ha
Dear All,
Need ur advise...
I got around 20 text files in a day,which had 13 to 15 columns separated by
"|" this sign. each file contains around 15 lacs or more line items.
when i import that text file in excel 2007, it takes the first 10 lacs
records; rest does not come.
Need ur help to solve