Trevor Best wrote:
friend05 wrote:
hi,
i am having an txt file; from which i want to extract some data and
arrange it in a tabular format so that i can use in ms-access.
can anyone suggest how should i do it?
If the text file is structured into a table format (fixed width, comma
delimited, etc) then just import it (File->Get External Data->Import).
If there's no structure then you're SOL unless you're adept at BASIC I/O
but this isn't the place to learn that.
The Open, Close, Read, Print, Put, Write, Get, Read, Input statements
and VBA examples can help tho.