Creating table in Access using C#

[Johnny E Jensen]

Hello Group

I have made an application that can create Mail Merges with Word. The
application creates a WordTemplate and set the
Document.MailMerge.OpenDatasource's filename to a text (tab spe.) file.
Containing all fields and data to merge with.

I would like to change the MailMerge.OpenDatasource's datasource to an
Access database instead.

In another table i have a list of fields that can be used in the mailmerge.
These fields can change from time to time, and therefore i will have to
change the table that i used as the MailMerge datasource table.

So: I'll need to first Delete the table - easy - just Execute the SQL "DROP
TABLE [tablename];"
Then create the table with the columns matching my merge fields..

How can i create a new table in Access 2003 using C# and Visual Studio 2005

Kind Regards
Johnny E. Jensen

 

[Kerry Moorman]

Johnny,

http://msdn2.microsoft.com/en-us/library/aa140011.aspx

Kerry Moorman

 

[Cor Ligthert[MVP]]

Johnny,

To add to Kerry's message.

In AdoNet it means to use OleDB and then almost the same as with SqlClient,
with some slight changes.

www.connectionstrings.com

Cor