populating an access database...

[RAB]

I want to populate my access database with strings which are coded as
follows:
{
{"string1"},
{"string2"},
{"string3"},
......
{"string100"},
{"string101"},

}
I have 200 of these string lists that I want to populate an access data

base.

Without having to copy and paste each string individually, is there
anything I could do that would be simpler and faster?
Thanks,
RABMissouri

[Salad]

RAB wrote:

I want to populate my access database with strings which are coded as
follows:
{
{"string1"},
{"string2"},
{"string3"},
......
{"string100"},
{"string101"},

}
I have 200 of these string lists that I want to populate an access data

base.

Without having to copy and paste each string individually, is there
anything I could do that would be simpler and faster?
Thanks,
RABMissouri

Where are the "strings" coming from? A Text file? If so, look at
LineInput/Open/Close and code examples in help to read the file.

Look at "Instr()" in help to see where something exists in a string if
you need to parse out data.

Look at "Insert Into" in help to insert a record or look at "AddNew" in
help and their code examples.

[Steve]

If you're just going to put these strings into your database once, you
can use the Import Table feature in Access. Open your db, go to the
Tables tab, right-click and choose "Import...". From there the wizard
takes you through it.