how to connect an access file or excel file with vb6? does latest vb version supports ms access 2007?

If you use 'Data1' control , then you can connect with MS Access or MS Excel Database by change

'Connect' Property of 'Data1' control

(By Default it will be MS Access, But you may change it to MS Excel)

The problem with Data1 is that it support old version of MS Access.

--------------------------------------------------------------------------------------------------------

You can also use 'Adodc1' to connect with MS Access Database

(Project->Component , Check Microsoft ADO Data Control (OLE DB), then Click on OK)

Click on Property 'Connection' String of Property ADODC1 control,

click on Buid Button

from List of Providers select

Microsoft Jet 4.0 OLE DB Provider

( if you want to connect MS Access Data base)

But for MS Excel Database we need to Create a DSN ( Data source name)

To Create DSN, you follow these

------------------------------------------------------------------------------------------------------

Start -> Control Panel -> Administrative Tools -> Data Source(ODBC)

Click on Add, Select 'river Do Microsoft MS Excel', Click on 'Finish' Button,

a Dialog Box will appear, Give name on 'Data Source Name' Text Box as your Choice,

click on Button 'Select Work Book'

and Browse your Excel File , and give OK, Ok

============================================================