Microsoft Access table

Post any question you may have in regards to GoAnywhere Director and let our talented support staff and other users assist you.

Microsoft Access table

Postby progers » Tue Apr 08, 2014 1:56 pm

I’m trying to find out if there’s any way to read in a table from a Microsoft Access database. Using GoAnywhwere.

I chatted online with Duane and found out there's no Access JDBC driver available but was wondering if I could somehow use an ODBC connection set up with an Access driver?

Just don’t want to spin my wheels if it truly cannot be done.

Thanks
Paul
progers
 
Posts: 5
Joined: Mon Feb 10, 2014 10:33 am

Re: Microsoft Access table

Postby Support_Jon » Tue Apr 08, 2014 3:08 pm

Hey Paul,

You are in luck as you can connect to a Microsoft Access Database using GoAnywhere Director. GoAnywhere uses the very popular JDBC standard for connecting to databases. A JDBC bridge (or access gateway) is available to bridge the gap to your OBDC connection, you just need to track down the one specific to your version of Microsoft Access. Although Director doesn't include the needed driver by default, it is possible to download the driver and use it with our application.

Simply download the driver from the online source of your choosing and install it into our application and follow that with a restart. Then you will be able to easily retrieve the data you need from your Microsoft Access Database.

Please follow the instructions found in this forum post to aid you in placing the downloaded.jar file into the appropriate folder within GoAnywhere. post163.html#p163
Support_Jon
Support Specialist
 
Posts: 48
Joined: Thu Jul 19, 2012 9:15 am
Location: Ashland, NE


Return to Community Forum

Who is online

Users browsing this forum: No registered users and 2 guests