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

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;EN-US;Q278973

Here is more information about how to connect to Excel Workbooks through
HOWTO: Use ADO with Excel Data from Visual Basic or VBA;EN-US;Q257819

Elan Zhou
This posting is provided "AS IS" with no warranties, and confers no rights.
Got .Net?

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