Run Extra Macro on Access Data or Transfer it to Excel First

[JeaShe]

Hi all,

I want to run an Extra!Basic macro against data currently resides in an Access database. I don't know how to "getstring" data in Access then do what I need to do in Extra! then send confirmation/results to Access.

So since I'm very comfortable doing the same process in Excel I thought I might try to download the data from Access into Excel, run my macro there, then upload that data back to Access.

Do any of you have an opinion on how difficult it might be to do the process using Excel? What commands do I use to transfer the data back and forth? Or, is it a waste of time to transfer the data back and forth?

FYI I'm running the macro on around 11,000 records one time. So while it's a lot of records, it's a one-time run.

Thanks for any help! I also posted this on the VBA board for their advice.

 

[IknowMe]

Id skip the EB and write my script in Access VBA. If your comfortable with Excel VBA you shouldn't have any problems with Access. There's another TT forum for any Access VBA questions you may have regarding getting/modifying data on your table.

forum705

Any questions about using Attachmate objects can be answered here.

[small]Sometimes you gotta leave your zone of safety. You have to manufacture Inspirado. You gotta get out of the apartment. You've got to run with the wolves. You've got to dive into the ocean and fight with the sharks. Or just treat yourself to a delicious hot fudge sundae........ with nuts. - Jack Black[/small]

 

[JeaShe]

Thanks. I did finally post in Access site you recommended. I also wondered if anyone had some EB code that ran against and Access database they could share so I could try out that route. Thanks again.

 

[Skie]

I don't know for sure if there's an Access object you can load. But, I think you can use ADO on an Access DB.

set conn=Server.CreateObject("ADODB.Connection") 
conn.Open "myDB"

This is a pretty good reference (though web-oriented) for using ADO:

http://www.w3schools.com/ado/default.asp

 

[IknowMe]

Set it up the same way you do Excel, here's a reference for the object, properties, methods ex.

http://msdn2.microsoft.com/en-us/library/aa191636(office.10).aspx

[small]Sometimes you gotta leave your zone of safety. You have to manufacture Inspirado. You gotta get out of the apartment. You've got to run with the wolves. You've got to dive into the ocean and fight with the sharks. Or just treat yourself to a delicious hot fudge sundae........ with nuts. - Jack Black[/small]

 

[JeaShe]

Ok. Thanks. I was looking at this through Access Help last week. Just got to put it all together. Thanks