J JimmiDill New Member Joined Sep 10, 2002 Messages 10 Sep 13, 2002 #1 How can I export a row of data in Excel and Paste Append into an existing table in Access? Thanks
M MarkHenri Board Regular Joined Aug 2, 2002 Messages 106 Sep 13, 2002 #2 Check out the MS KB article Q145826 and see if that gives you some ideas. I've been wanting to try this for a while and I'll see if I can get an example working shortly.
Check out the MS KB article Q145826 and see if that gives you some ideas. I've been wanting to try this for a while and I'll see if I can get an example working shortly.
NateO Legend Joined Feb 17, 2002 Messages 9,700 Sep 13, 2002 #3 Howdy, also, there's some ADO code posted on this site: http://www.mrexcel.com/board/viewtopic.php?mode=viewtopic&topic=12494&forum=2&start=0 You'll want to change your input range, and the drive/filepath. Have a nice weekend.
Howdy, also, there's some ADO code posted on this site: http://www.mrexcel.com/board/viewtopic.php?mode=viewtopic&topic=12494&forum=2&start=0 You'll want to change your input range, and the drive/filepath. Have a nice weekend.
H Hero-0952 Wizard Deluxe Joined Jun 11, 2002 Messages 348 Sep 13, 2002 #4 Never mind this reply - everyone posted while I was formulating a response . . . LOL! Regards, ViperGTS This message was edited by ViperGTS on 2002-09-13 14:45
Never mind this reply - everyone posted while I was formulating a response . . . LOL! Regards, ViperGTS This message was edited by ViperGTS on 2002-09-13 14:45