How to save to database

[clara]

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

 

[Bob I]

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

 

[clara]

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

 

[Bob I]

You're welcome, have a good day!