| 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 | |||
Hybrid Mode
