Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
import from excel to access with macro?
Have existing access table.
Imported data from the following source. C:\Documents and Settings\jw\Desktop\[error_report_play.xls]Sheet3 Need macro in access that will return to the same data location and copy all of the data to the next available row in the table. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
import from excel to access with macro?
You need to use ADODB Recordsets to do that via a macro. It is not distinctly
difficult but it does require a bit of know how. -- HTH... Jim Thomlinson "J.W. Aldridge" wrote: Have existing access table. Imported data from the following source. C:\Documents and Settings\jw\Desktop\[error_report_play.xls]Sheet3 Need macro in access that will return to the same data location and copy all of the data to the next available row in the table. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
import from excel to access with macro?
thanx!
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I get Excel to import XML like Access? | Excel Programming | |||
macro to import access data into excell | Excel Programming | |||
VB Code or Excel macro to run Query/Import on Access file | Excel Programming | |||
import access into excel | Excel Programming | |||
I can import Access Tables. But, I can't import Access queries | Excel Programming |