convert txt file to ms-access [modified]

[Rinki Mukheraji]

How convert txt file to ms-access please urgently for e.g txt file format [2007/09/01-00:04:58]/1/0/5/0 Details Date Time Id Id Id Id [2007/09/01 - 00:04:58] /1/ 0/ 5/ 0 -- modified at 2:22 Tuesday 9th October, 2007

[pmarfleet]

Gagan Deep Garg wrote:

please urgently

It's rude to say this. It can't be that urgent, otherwise you would be paying someone for assistance. Doesn't Access have a text file import facility?

Paul Marfleet

[Salman Sheikh]

you will have to parse the string for doing this :) you can create an access database with a table with your required schema and then start reading file using streamreader line by line and split every line on separator and use the literals as values for your access datatable

Salman Sheikh