Excel to Access
[163 byte] By [Atticus] at [2007-11-11 7:36:32] 
Hi, I was wondering if anyone knew how to send certain Excel cells to particular Access tables in Visual Basic. Any help would be appreciated very much. Thanks! :)
# 1 Re: Excel to Access
If this is a one-time or rare task, you can use the FILE > Get external data... features in Access. This will let you import data from Excel, select the sheets or named ranges, set data types, choose which columns to import and whether the first row is column headers.If this is a process you need to put in place, the link below shows a macro from ExcelTip.com that does just this.
Excel to Access VBA Macro (http://www.exceltip.com/st/Export_data_from_Excel_to_Access_(DAO)_using_VBA_in_Microsoft_Excel/426.html)
Good luck,
msanchez at 2007-11-11 17:26:47 >
# 2 Re: Excel to Access
Thanks for your help its always easier when you have something to work from. This will be a weekly process and I just wanted to make it easy on the user to just push a button and all the data will be converted to its correct places.Atticus at 2007-11-11 17:27:46 >
