IonicWind Software

IWBasic => Database => Topic started by: splakidas on March 27, 2007, 03:30:18 AM

Title: add data to excel
Post by: splakidas on March 27, 2007, 03:30:18 AM
how can i add data to  excel tables ?
Title: Re: add data to excel
Post by: Jerry Muelver on March 27, 2007, 05:45:45 AM
Choose one of Excel's file open options, and tailor your files to match -- CSV, DIF, SYLK, dBASE, for instance. Depending on the type of data, you might instead use Data > Get External Data > Import Text File.
Title: Re: add data to excel
Post by: splakidas on March 27, 2007, 03:55:35 PM
I want to add data using ebasic   to an existing excel sheet !!!  :)
Title: Re: add data to excel
Post by: Rod on March 28, 2007, 07:51:58 AM
There is an ODBC driver for Excel which you may be able to use. I found information on it here:

http://msdn2.microsoft.com/en-us/library/ms711711.aspx (http://msdn2.microsoft.com/en-us/library/ms711711.aspx)
http://www.codeproject.com/database/excel_odbc_write.asp (http://www.codeproject.com/database/excel_odbc_write.asp)
http://www.codeproject.com/database/excel_odbc.asp (http://www.codeproject.com/database/excel_odbc.asp)
Title: Re: add data to excel
Post by: splakidas on March 28, 2007, 08:14:57 AM
Thank you Rod the second link is helpfull i think.