Excel to Access using ADO
 

Please help if possible.

I would supply what I have so far, but it is really
convoluted garbage.

I am using ADO 2.5 in VBA from Excel XP with Windows 2000.

I have loaded an array with data from a spreadsheet.

Now, I need to copy it into a recordset (I guess) to
upload into an Access database (table exists and all
fields match).

I have seen many examples, but none seem to work. Can
someone supply me with example code on how to do this
please, please, please?

Your example code is most valuable thing I could get.
Thanks in advance.

Excel to Access using ADO
 

Here is a quick something. It is not perfect but it is a workin
example.


Keith
www.kjtfs.co

Attachment filename: database.zip
Download attachment: http://www.excelforum.com/attachment.php?postid=39262
--
Message posted from http://www.ExcelForum.com

Excel to Access using ADO
 

Thank you very much, it worked!

-----Original Message-----
Here is a quick something. It is not perfect but it is a
working
example.


Keith
www.kjtfs.com

Attachment filename:
database.zip
Download attachment:
http://www.excelforum.com/attachment.php?postid=392625
---
Message posted from http://www.ExcelForum.com/

.

Excel to Access using ADO
 

Hi Keith,
I tried it too and it worked, I will certainly use it for my database
Thank you,
Annelie:)


---
Message posted from http://www.ExcelForum.com/

Excel to Access using ADO
 

Little Problem with my macro. Until now a ran a macro which sorted an
prepared the data to be imported to access. In the end range selectio
looked like this:
Range("A2").Select
Range(Selection, Selection.End(xlToRight)).Select
Range(Selection, Selection.End(xlDown)).Select
using end right, end down, because the data is not always the same
Actually the columns are always the same, but the rows are not..

How do I translate that to your macro?
Thanks in advance.
Annelie

--
Message posted from http://www.ExcelForum.com