469,282 Members | 1,787 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,282 developers. It's quick & easy.

Saving a data table to a MS Access database

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
5 5618
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
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
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
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
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.

Similar topics

6 posts views Thread by S. Graefner | last post: by
2 posts views Thread by jessDMiller | last post: by
3 posts views Thread by Nathan Guill | last post: by
1 post views Thread by nmrpa91290 | last post: by
1 post views Thread by CARIGAR | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.