SQL Update for MS Access Database from ODBC Shopify Source

We are a small non-profit art gallery, and we have a gallery shop in Shopify. We also have an MS Access Database with contacts that are linked to... Artwork sales, event booking, donations, exhibitions, creators of artworks in database, etc. So we need to keep these MS Access Database contacts updated when people update their details in their shopify account. We also have membership dates stored in MS Access: join date, renew date, and expiry date (can be 1, 2, or 3 years from renewal/join date). People can buy a membership in Shopify, and we would like to update the MS access contacts with their new dates.

We have been able to get the shopify tables into MS Access via linked table manager using ODBC. (We use a driver from CData, you can get a free trial to assist with development).

Experience with the shopify tables would be preferred but not necessary. The main work is writing the SQL Update Query. The info required seems to be across 4 tables in Shopify: Customers, Customer Addresses, Orders, Order Items.

Skills: Microsoft Access, MySQL, Database Programming, SQL

See more: project mysql database access using odbc, moving tables sql server 2000 access database cnet, problem access sql update, import sql dump ms access, migrate ms access database sql server, ms frontpage update ms access database, perl script update ms access webform, php odbc connect ms access database, sql website ms access, sql server express access 2007 odbc, visual studio sql update database access, tim finch contract mysql ms access vba sql server database developer, ms access odbc connection to sql server, ms access link to sql server without odbc, import ms access database to sql server, how to link ms access database table to sql server, ms access vba odbc connection to sql server, dbms and sql with ms access ms sql server

About the Employer:
( 0 reviews ) TOWNSVILLE CITY, Australia

Project ID: #30958420

Awarded to:

(34 Reviews)

32 freelancers are bidding on average $411 for this job

(226 Reviews)

[login to view URL] I have gone through your project requirements. I will develop access application for you. It will connect with Cdata via ODBC and will write queries to update the dates and contacts in your access database I More

$300 AUD in 5 days
(514 Reviews)
(200 Reviews)
(28 Reviews)

Hi, I’ve read your project description and is a lot like projects I’ve done in the past both with customers from this site as well as personal projects. I feel confident that I can work on it with you. Send me a messag More

$550 AUD in 7 days
(29 Reviews)
(16 Reviews)

Hello, We have seasoned Full stack developers for mobile and web developments, We have developed many solutions in Object C, Swift, Java, Kotlin, React Native, Flutter, Xamarin, etc. and in Shopify, Woo Commerce, Reac More

$750 AUD in 7 days
(5 Reviews)
(32 Reviews)
(4 Reviews)
(21 Reviews)
(5 Reviews)

I'm an experience MS Access and vba developer, have been in this field for more than 10 years and working many MS Access or MS Access related project (using other development platforms). I'm also Brainbench MS Access c More

$250 AUD in 3 days
(34 Reviews)
(2 Reviews)

Hello, I have been working as a professional angular developer for 8 years and I've gained rich experience with it in other companies. Please review my portfolio if you have one sec. Basically, I've investigated your r More

$750 AUD in 5 days
(8 Reviews)

[login to view URL] [login to view URL] Hello Dear Employer I'm a expert developer with about 14 years experience and have rich More

$650 AUD in 15 days
(7 Reviews)
(2 Reviews)

Hello, I would like to help you, I have more than 10 years of experience working with MYSQL, POSTGRESQL, SQL SERVER, MARIADB, in many of its versions. It is my specialty en SQL y PL/SQL.

$250 AUD in 7 days
(13 Reviews)

Hi guys, I believe I can help you with the task. Do you want the sync to be done as a full export/import or you want just a delta to be pushed from shopify to access? both variants can do the job, the important bit is More

$400 AUD in 7 days
(7 Reviews)

Hi, I have gone through your requirement and I am able to help you with it. 8+ years of professional experience with DB designing and management for global tech companies. Well versed in DB administration, designing an More

$250 AUD in 3 days
(12 Reviews)

Hello, I will be glad to assist you with that. I am an experienced Data Scientist and Data Visualization expert holding years of experience in performing Data Visualization, Data Analytics and Automation using Power BI More

$300 AUD in 1 day
(3 Reviews)