Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 425
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5,939
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 425
Default import from excel to access with macro?

thanx!
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can I get Excel to import XML like Access? Ed from AZ Excel Programming 10 December 5th 07 05:27 PM
macro to import access data into excell GerryE Excel Programming 0 July 11th 06 10:53 PM
VB Code or Excel macro to run Query/Import on Access file Harry[_8_] Excel Programming 13 February 22nd 05 08:27 PM
import access into excel sal21[_39_] Excel Programming 1 November 9th 04 01:15 AM
I can import Access Tables. But, I can't import Access queries nickg420[_8_] Excel Programming 0 August 5th 04 07:46 PM


All times are GMT +1. The time now is 07:14 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"