Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 252
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,819
Default 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


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 252
Default 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



  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,819
Default 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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
save excel 2007 file as database III TammyThack Excel Discussion (Misc queries) 2 December 6th 07 01:59 PM
database query not showing foxpro database How I import data mangat New Users to Excel 1 June 24th 07 03:31 PM
How to make reference to database and if true copy from database? V!p3r Excel Discussion (Misc queries) 4 February 5th 07 02:19 PM
save a entry in database for the items in list Dr. Akash Rajpal New Users to Excel 1 January 6th 06 07:40 AM
How do I save a record from an excel template to a database in a . Fred Smith Excel Discussion (Misc queries) 1 November 30th 04 01:49 PM


All times are GMT +1. The time now is 06:06 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"