Excel

[JimmiDill]

How can I export a row of data in Excel and Paste Append into an existing table in Access?

Thanks

 

[MarkHenri]

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]

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.

 

[Hero-0952]

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