Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
Grd Grd is offline
external usenet poster
 
Posts: 118
Default How to Push Data from Excel into Access?

Hi,

I'm contemplating a scenario and I'm not sure if this is the best approach.

I'm pulling data into Excel from Access using MSQuery. Making some
modifications to certain records. I would like to push these changes back to
Access.

MSQuery can't feed these excel changes back I'm guessing (?) so I'm thinking
that I will push the modified records back into a new table in access and
somehow merge the changes back into the original table perhaps through VBA.

I need some guidance with my approach. Is there an easy way of doing this?

Any help would be great

Thanks
Suzanne
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 812
Default How to Push Data from Excel into Access?

http://erlandsendata.no/english/index.php?t=envbadac

Hth,
Merjet


  #3   Report Post  
Posted to microsoft.public.excel.programming
Grd Grd is offline
external usenet poster
 
Posts: 118
Default How to Push Data from Excel into Access?

Thanks Merjet

Interesting link

S

"merjet" wrote:

http://erlandsendata.no/english/index.php?t=envbadac

Hth,
Merjet



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
how to push data to another cell Wawa Excel Worksheet Functions 1 May 31st 07 05:49 PM
Importing data from Access to Excel, but I need to vary the table from Access Liz L. Excel Programming 3 June 6th 06 02:12 AM
Push/write data into an unopened file Rod Excel Worksheet Functions 2 March 27th 05 03:29 PM
Access data -work in Excel- save in Access s_u_resh Excel Programming 1 October 25th 04 12:52 PM
Using MS Query to Push Data to Oracle Chris Rettke Excel Programming 1 January 30th 04 12:58 PM


All times are GMT +1. The time now is 04:28 AM.

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"