By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,302 Members | 1,716 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,302 IT Pros & Developers. It's quick & easy.

populating an access database...

P: n/a
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

Nov 14 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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.
Nov 14 '05 #2

P: n/a
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.

Nov 14 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.