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.

Taidot: Microsoft Access, MySQL, Tietokantaohjelmointi, SQL

Näytä lisää: 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

Tietoa työnantajasta:
( 0 arvostelua ) TOWNSVILLE CITY, Australia

Projektin tunnus: #30958420

Myönnetty käyttäjälle:

(34 Arvostelua)

32 freelanceria on tarjonnut keskimäärin $411 tähän työhön

(226 arvostelua)

[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 Lisää

$300 AUD 5 päivässä
(514 arvostelua)
(200 arvostelua)
(28 arvostelua)

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 Lisää

$550 AUD 7 päivässä
(29 arvostelua)
(16 arvostelua)

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 Lisää

$750 AUD 7 päivässä
(5 arvostelua)
(32 arvostelua)
(4 arvostelua)
(21 arvostelua)
(5 arvostelua)

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 Lisää

$250 AUD 3 päivässä
(34 arvostelua)
(2 arvostelua)

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 Lisää

$750 AUD 5 päivässä
(8 arvostelua)

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

$650 AUD 15 päivässä
(7 arvostelua)
(2 arvostelua)

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 7 päivässä
(13 arvostelua)

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 Lisää

$400 AUD 7 päivässä
(7 arvostelua)

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 Lisää

$250 AUD 3 päivässä
(12 arvostelua)

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 Lisää

$300 AUD 1 päivässä
(3 arvostelua)