getting a direct input from excel table 
Author Message
 getting a direct input from excel table

i need access to an excel table directly, not using data control cause it
has only drivers for excel 8.0 or 7.0. i need to get access in any of
versions 97-XP. how can i do it?


Fri, 25 Feb 2005 18:14:19 GMT  
 getting a direct input from excel table
Hi,

As mentioned in the following article, if you are using Jet OLE DB provider
to open Excel workbooks, it can open 95/97/2000/XP workbooks.
SAMPLE: ExcelADO Demonstrates How to Use ADO to Read and Write Data in
Excel Workbooks
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q278973

Here is more information about how to connect to Excel Workbooks through
ADO:
HOWTO: Use ADO with Excel Data from Visual Basic or VBA
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q257819

Regards,
Elan Zhou
This posting is provided "AS IS" with no warranties, and confers no rights.
Got .Net?  http://www.gotdotnet.com



Sun, 27 Feb 2005 11:28:48 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. From Table To Excel - From Excel To Table

2. HELP: Getting table data from EXCEL via Exel OBJECT and then dumping result in Flexgrid

3. Detecting Duplicate Entries On Direct Input

4. direct input vs BCP

5. Direct Input in VB 5 from Soundblaster live

6. Shell and re-directed input

7. Direct Input : Action Mapper

8. Direct Input problem

9. direct input error

10. Knowing program input while using Direct Draw 7.

11. Direct Input :: Foot Pedal Axis question

12. direct input

 

 
Powered by phpBB® Forum Software