VB Macro Code to Save Excel Ranges in Access Tables

R

Rajesh

Hi,
I tried searching for this solution in the entire forum but could not find
relevant answer.

I have excel sheets and I need to save certain ranges of this data into
access tables..The idea is to automate it as much as possible using VB Macro
code in Command buttons placed in Excel sheet.

Can someone please provide code snippet to connect to database from excel
and save the data into access?
 
H

Harbinger

I'm not sure if excel can write in access tables

but it is possible to create an excel sheet which is used as access table
(from access use the link feature instead of import new table)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adjusting the layout of over 1000 existing Word documents using a macro-driven batch run 0
Excel 2010 Table not showing in Access 2010 Import List 0
Table Security in Access 2013 1
Import data from Access to Excel containing VB code 3
Excel macro code for copying data to a cell reference which is set byvalues in two separate cells in 3
Import Excel 2010 table into Access 2010 - not listed as range 0
ListObjects - VBA code that worked in previous versions of Excel doesnot work in Excel 2013 0
Macro to email via MAC (Code for Outlook working) 1

Top