Putting a new datatable from VB to Access

[Sibs]

I need to create a new datatable in my VB .net code and then when I have filled the datatable I want to send this to an empty Access table.

 

When I have looked at the books they all talk about doing a SELECT statement first which brings back the data already in the Access table. I don't want to do this. the table is created in the VB code.

 

Any ideas?

[archer_coal]

RE:

 

take a look at this post

it give a good example of Select Insert Update methods for access db

 

http://www.xtremedotnettalk.com/t69746.html

 

you might also want to take a look at msn for datasets and how they work if you want to build an entire table.

[Nerseus]

It sounds like you want to actually create a table that doesn't exist? You'll have to run a query that creates the table, such as "CREATE TABLE table1 (column1 int, column2 int)". I don't know the syntax for doing this in Access, you'll have to check the help.

 

It's definitely NOT as simple as creating a table in code in a DataSet and having some built-in .NET objects create that table in Access for you. You'll have to run a script (the name for an SQL "query" that doesn't really query the database, but instead performs some action) as shown above.

 

-ner