How to save to database
 

Hi all,

I know a range has CopyFromRecordset method to dump data onto a sheet, I am
wondering how to save data back into database.

Clara
--
thank you so much for your help

How to save to database
 

I think you will need to Import from the database side.

clara wrote:

Hi all,

I know a range has CopyFromRecordset method to dump data onto a sheet, I am
wondering how to save data back into database.

Clara

How to save to database
 

Hi Bob,

You are right. I just rember that I had done a similar task when I was in a
SQL Server administration training course, then I had input a text file into
a table using a built-in tool in SQL Server .

Thanks

Clara
--
thank you so much for your help


"Bob I" wrote:

I think you will need to Import from the database side.

clara wrote:

Hi all,

I know a range has CopyFromRecordset method to dump data onto a sheet, I am
wondering how to save data back into database.

Clara

How to save to database
 

You're welcome, have a good day!

clara wrote:

Hi Bob,

You are right. I just rember that I had done a similar task when I was in a
SQL Server administration training course, then I had input a text file into
a table using a built-in tool in SQL Server .

Thanks

Clara