accessing Tab delimited raw file and store in database using visual basic

[Syed Mustafa]

i am a visua basic programmer. i have a problem. i tried to solve it but didnt succeed. we received a credit card details in a text file which is very big. some 100 of records and in between many tab / spaces are there. what i have to sort is take card no, name, amount , transaction id. but the file containing to many column. please help in takeing the information from the file.

it have many customer and customer wise transaction.

[hariharanmca]

i am a visua basic programmer. i have a problem. i tried to solve it but didnt succeed. we received a credit card details in a text file which is very big. some 100 of records and in between many tab / spaces are there. what i have to sort is take card no, name, amount , transaction id. but the file containing to many column. please help in takeing the information from the file.

it have many customer and customer wise transaction.

1. Can you post some sample data which you are getting?
2. Front-End and Back-end versions?

[Killer42]

1. Can you post some sample data which you are getting?
2. Front-End and Back-end versions?

Samples of code and data would be helpful, but I certainly hope you won't be posting real credit card details here!

As for the general topic of accessing tab-delimited data in VB, it's usually quite simple. You read the file a line at a time, and use the Split() function to split the fields into an array. Or, you might be able to trigger the database's Import function and let it handle the data.