ODBC & VBA

Posted by Pamela on January 29, 2002 7:33 AM

How would I make a connection to an Access table from Excel using VBA? I want to pass data back and forth seamlessly without the user realizing it. Thanks to all you VBA'ers.

Posted by David Gibson on January 29, 2002 9:47 AM

I don't think you need to use VBA to do this. One of the addins that come with Excel is a Access Links. You can create an Access database using existing Excel data. You can use an Excel spreadsheet as a data entry form for Access and vice versa.