Data Connection from Excel to Access

Deniz Yalman

Guest

Posts: n/a

3rd Mar 2008

Hi all,

I want to create dynamic data connection from excel 2007 to access mdb file
with vba and then list data table to worksheet.

I use "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\blabla.mdb;"
connection string.

But i have no idea about handling coming data and writing to the sheet.
Could anyone show an example to me?

Thanks in advance.

« XL2002 - Application Resize Event... | Cut data in 2nd row and paste in the end of 1st row »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel 2010 (64 bit) External Data connection with Access	Bill Carlson	Microsoft Excel Misc	0	2nd Jun 2011 12:10 AM
Data Connection: Access Query to Excel How to get rid of header ro	Der Musensohn	Microsoft Excel Programming	3	26th Feb 2010 04:28 PM
Excel data connection to Access not retrieving data from single fi	dandc0711	Microsoft Excel Programming	0	12th Jan 2010 03:52 PM
Excel data connection to Access	Sharon	Microsoft Excel Misc	1	14th Feb 2008 08:33 PM
Access Data in Excel Connection Errors	=?Utf-8?B?VGhvbWFzIEw=?=	Microsoft Access VBA Modules	9	17th Oct 2005 03:34 PM