Export Excel Data to Access With a Macro!!!

[Jac]

Hi,

I have been trying to create a macro in excel to automatically export data
into access, but to no avail. Would somebody please give me a hint?
Your assistance will be greatly appreciated.

Thanks

 

[vb_Sagacious]

Using Access either "Link" the spreadsheet as a table or import the excel data.
Otherwise research ADO and CreateTable to learn how to push the data cell by
cell.


Ken

 

[Jac]

What I am trying to do is to copy certain tab [spreadsheet] and Paste Append
onto Access. Therefore, neither importing nor linking will do it.

Thanks

 

[vb_Sagacious]

Appending an entire "tab [spreadsheet]" would require that you use Access's
Import. However if you Link the specific "tab [spreadsheet]" you can use
queries to manipulate the data both ways, including in and out of an existing
table...

Nevertheless, you will want to create your spreadsheet (.xls File), save it
and then work from Access to pull the data. Otherwise, like I mentioned you
could push the data using ADO, but this is much more difficult and would
require more than just simple macro knowledge.

Hope this helps,
Ken

What I am trying to do is to copy certain tab [spreadsheet] and Paste Append
onto Access. Therefore, neither importing nor linking will do it.

Thanks

Using Access either "Link" the spreadsheet as a table or import the excel data.
Otherwise research ADO and CreateTable to learn how to push the data cell by
cell.


Ken