🚀 go-pugleaf

Hi Stan,

Use tdaodataset - generally works faster.

You can use an sql query to suck up the text file and insert into your
table.  You can also do this:

Assuming, commandtype tabledirect

TADoDataset->Insert();
TADODataset->FieldByName("LastName")->AsString = "Smith"  // or text
...
...
...
TADODataset->Post();

Autoincrement field takes care of itself.

-Jerry




On Wed, 7 Aug 2002 18:50:55 -0700, "John Romow" <holjar@masen.net>
wrote:

>Hi. I have a rather simple MS Access mdb with 3 tables, and I'm working
>with just one of the tables. I managed to figure out how ot open it
>(ahem, "connect" to it that is) with a TADOConnection and now I'm trying
>to use a TADOTable to add entries. The table connects ok (I have the
>Connection property set to the TADOConnection adn I can select the table
>I want.
>
>My question is: how can I add entries (I have them stored in a text
>file - a list of last and first names that I want to stick into my
>table).
>
>I've looked through the help but I keep getting stuck. I admit I'm
>rather new to working wth DBs in BCB (but not new to BCB!).
>
>Here are the Fields in my table:
>
>| ID | Last Name | First Name | Email |
>
>(I'm only working with the middle two)
>
>And one more note, ID is an AutoNumber field, so will BCB take that into
>account?
>
>Thanks a lot here, I am getting desperate, as I've been trying for about
>a week on my own here, looking through the help file and all. I even
>tried Google too.
>
>Thanks
>
>~ Stan
>