Jump to content
Sign in to follow this  
KyleC

Access Table Export Help

Recommended Posts

KyleC

alright, after a few hours of searching and reading all over the net, I have broken down and decided to ask for help. I am working to automate many of the more medial and repetitive tasks as work, and stumbled upon AutoIt, I love the tool. anyway, Today's task is the export of a slew of tables and queries from Access 2007 in a few different formats. mostly CSVs some Tab delimited, and a couple of dBase DBFs and DBTs. now none of this is all that difficult and in fact the person who previously held my position created about a hundred Macros in the mdb that export the tables. seems to me that he fell well short of hastening the process as you still have to run each macro. I am looking to create an autoit script that will export the correct tables in the correct format to the correct place with the correct name. doesn't seem like it should be that difficult.

so thus far I have been imagining using ADO to tell Access to export which table in which format and where. but I cannot seem to find the necessary commands needed to do that. I also figured that perhaps, at least with the text based formats (CSV, txt, tab) I could read each record out of a given table or query and then build the text file myself in autoit, not the simplest way of doing it, but it could work. The problem arises when trying to create the dBase file, I haven't a clue where to begin with that.

I should note that I am fairly new at both AutoIt and ADO. the syntax in ADO seems to elude me frequently. so, any and all help is appreciated, please refrain from the "Just google it" responses. if you have a link to share, or a resource that you have found helpful please post that as well, I am not allergic to reading or doing research. Sometimes it just makes more sense to ask for help.

Thanks,

Kyle

Share this post


Link to post
Share on other sites
KyleC

Apparently the task is simple if you use VBA, just use the DoCmd.transfer___ fil in the blank to determine which output format. problem is, I don't really have the time or patience to learn VBA at the moment. so new question is, is there a way to use the DoCmd object that VBA uses in AutoIt, or is there an equivilent object I could use with AutoIt?

Any and all help is appreciated.

Share this post


Link to post
Share on other sites
KyleC

no replies?

A little help? please? I have been putting this to the back burner and now I am looking into it again, anyone got some ideas?

Share this post


Link to post
Share on other sites
Juvigy

Try this: Change the paths and table name as you want

$oAccess = ObjCreate("Access.Application")
$oAccess.Visible = 1
$oAccess.OpenCurrentDatabase("C:\Database1.accdb")
$oAccess.Application.DoCmd.TransferText(2,default,"Assets","C:\logs\April.csv")

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×