Database number adding

[Hojomojo]

Heeeelloo
I haveing a wee bit of trouble with my VB prodject. Im new to Vb and pretty much know jack all. At the moment i have a database in which my VB prodect accesses and call bits from it. What i need to do is copy a load of stuff to a new DB, (which ive figured out) but i need to add the price of each product to the end of the list and print it out in a lickle text box in Vb, and also call it back later sort of thing. Its a collage thing incase anyone wondered, but any help tis much appreciated.

Please help!

Hojomojo

[mvrp350]

For that specific table I would not use a copy. I would read the table, using ADO, and programmaticly create a new table where you are able to add a new field for the pricing.
If you are using an Access DB you can use the TransferText command, open the newly created textfile line per line and save it to a new textfile. On the first line you add a new field for the pricing. In the following lines you add the price or an empty field. Finally you use the second file to create the new table. (I never have used that command from inside VB, but I think it's possible to do that).