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

Saving a data table to a MS Access database

P: n/a
Hi -

I've a data table that I want to save to an external Access database.

I'm interested in sample code that would perform this save.

Thanks, Mark
(VB.NET, .Net framework 1.0)
May 3 '06 #1
Share this Question
Share on Google+
5 Replies


P: n/a
Mark,

From where did you get your datatable?

You cannot create from a hand made datatable a database. This is maybe an
option for a next version from Visual Studio Net.

Cor

"Mark" <Ma**@discussions.microsoft.com> schreef in bericht
news:0C**********************************@microsof t.com...
Hi -

I've a data table that I want to save to an external Access database.

I'm interested in sample code that would perform this save.

Thanks, Mark
(VB.NET, .Net framework 1.0)

May 3 '06 #2

P: n/a
Cor -

The program populates a datatable from a connection to an Excel workbook.

It's in a loop, with each iteration the workbook is opened, calculates the
result, and the result is saved in a datatable residing in the VB program.

When the loop is done I want to save the datatable to an External Access
Database for use in other apps.

Thanks,
Mark

"Cor Ligthert [MVP]" wrote:
Mark,

From where did you get your datatable?

You cannot create from a hand made datatable a database. This is maybe an
option for a next version from Visual Studio Net.

Cor

"Mark" <Ma**@discussions.microsoft.com> schreef in bericht
news:0C**********************************@microsof t.com...
Hi -

I've a data table that I want to save to an external Access database.

I'm interested in sample code that would perform this save.

Thanks, Mark
(VB.NET, .Net framework 1.0)


May 3 '06 #3

P: n/a
You can issue DDL statements to Access like you would in SQL.

Take a look at
http://www.personal.kent.edu/~gthomas/sql/sqldoc.htm

"Mark" <Ma**@discussions.microsoft.com> wrote in message
news:EF**********************************@microsof t.com...
Cor -

The program populates a datatable from a connection to an Excel workbook.

It's in a loop, with each iteration the workbook is opened, calculates the
result, and the result is saved in a datatable residing in the VB program.

When the loop is done I want to save the datatable to an External Access
Database for use in other apps.

Thanks,
Mark

"Cor Ligthert [MVP]" wrote:
Mark,

From where did you get your datatable?

You cannot create from a hand made datatable a database. This is maybe an
option for a next version from Visual Studio Net.

Cor

"Mark" <Ma**@discussions.microsoft.com> schreef in bericht
news:0C**********************************@microsof t.com...
> Hi -
>
> I've a data table that I want to save to an external Access database.
>
> I'm interested in sample code that would perform this save.
>
> Thanks, Mark
> (VB.NET, .Net framework 1.0)


May 3 '06 #4

P: n/a
Why don't you create your DataBase with the appropriate blank table
containing all the fields you want. You can then fill a dataset with the
blank datatable from the database, update your dataset then when finished,
update the datatable in the database.
--
Dennis in Houston
"Mark" wrote:
Cor -

The program populates a datatable from a connection to an Excel workbook.

It's in a loop, with each iteration the workbook is opened, calculates the
result, and the result is saved in a datatable residing in the VB program.

When the loop is done I want to save the datatable to an External Access
Database for use in other apps.

Thanks,
Mark

"Cor Ligthert [MVP]" wrote:
Mark,

From where did you get your datatable?

You cannot create from a hand made datatable a database. This is maybe an
option for a next version from Visual Studio Net.

Cor

"Mark" <Ma**@discussions.microsoft.com> schreef in bericht
news:0C**********************************@microsof t.com...
Hi -

I've a data table that I want to save to an external Access database.

I'm interested in sample code that would perform this save.

Thanks, Mark
(VB.NET, .Net framework 1.0)


May 4 '06 #5

P: n/a
Mark,

This is a typical Paul Clement question, I thought that he has given answers
to do this direct instead of using OleDb.

Maybe he will answer you direct maybe you can otherwise yourself what he has
written about this.

http://groups.google.com/groups/sear...el&qt_s=Search

Cor

"Mark" <Ma**@discussions.microsoft.com> schreef in bericht
news:EF**********************************@microsof t.com...
Cor -

The program populates a datatable from a connection to an Excel workbook.

It's in a loop, with each iteration the workbook is opened, calculates the
result, and the result is saved in a datatable residing in the VB program.

When the loop is done I want to save the datatable to an External Access
Database for use in other apps.

Thanks,
Mark

"Cor Ligthert [MVP]" wrote:
Mark,

From where did you get your datatable?

You cannot create from a hand made datatable a database. This is maybe an
option for a next version from Visual Studio Net.

Cor

"Mark" <Ma**@discussions.microsoft.com> schreef in bericht
news:0C**********************************@microsof t.com...
> Hi -
>
> I've a data table that I want to save to an external Access database.
>
> I'm interested in sample code that would perform this save.
>
> Thanks, Mark
> (VB.NET, .Net framework 1.0)


May 4 '06 #6

This discussion thread is closed

Replies have been disabled for this discussion.