Odbc Jobs

3 were found based on your criteria {{ paging.total|number:0 }} were found based on your criteria

show all
  • Hourly ({{ jobTypeController.getFacetCount("0")|number:0}})
  • Fixed Price ({{ jobTypeController.getFacetCount("1")|number:0}})
Fixed-Price - Intermediate ($$) - Est. Budget: $80 - Posted
The goal of this project is to find an experienced database administrator with MySQL and Microsoft Access experience that can help me add my first two (relatively large) tables to MYSQL, preferably using MySQL Workbench. Additionally, I am hoping to set up an ODBC connection with Microsoft Access so that I can easily query (and join to) the data using Microsoft Access. ... Overview is shown below, but the attached file has more detail as to the contents of the tables. 1 Design simple MySQL DB for storage of Product Data (on my desktop) 2 The initial tables are currently available in either MDB files or in Txt files, whichever is easiest for you to use to import them into the MySQL DB 3 Msft Access ODBC Connection will be established so that Msft Access Queries can be performed on the MySQL Tables 4 Strive for the simplest possible setup, to ensure that queries and maintenance of the Database is as simple as possible for the Analyst using the data. 5 Note: I believe the MySQL and MySQL Workbench is already properly installed on my (desktop) computer, though we may need to ensure it is installed properly. 6 The initial two tables have around 2 Million records, but I will soon be growing them to 5 or 6 million records. 7 The reason for this project is because the size of the files in Msft Access have a 2 GB limit, so I am required to use a larger Database to house the data. 8 I will need to also have the ability to easily update/append/delete records in the below two tables, often times using lists of ASINs that exist in txt files or in Microsoft Access Tables.
Skills: ODBC Amazon MWS Apache CloudStack Database Administration