| || |
How to insert data into excel sheet using db_* functions
Can you help me how we can insert data into excel files using db_* functions.
Ashok Kumar G.
Re: How to insert data into excel sheet using db_* functions
This should get you started:
status = db_execute_query ( "Session1", "INSERT INTO [My_SpreadSheet$] VALUES ('aaa', 1234, 'bbbb)");
You can name the columns and use variables if you would like.
Keep us informed.
[ 09-20-2003, 01:51 PM: Message edited by: jpensyl ]