Đã hoàn thành

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.

Kĩ năng: Microsoft Access, MySQL, Lập trình cơ sở dữ liệu, SQL

Xem nhiều hơn: 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

Về Bên Thuê:
( 0 nhận xét ) TOWNSVILLE CITY, Australia

ID dự án: #30958420

Được trao cho:

(34 Đánh Giá)
5.7

32 freelancer chào giá trung bình$411 cho công việc này

(226 Nhận xét)
8.1
Prashantskin

[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 Thêm

$300 AUD trong 5 ngày
(514 Nhận xét)
7.3
(200 Nhận xét)
6.9
(28 Nhận xét)
6.3
fuentro

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 Thêm

$550 AUD trong 7 ngày
(29 Nhận xét)
6.0
(16 Nhận xét)
5.8
FiveExceptions

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 Thêm

$750 AUD trong 7 ngày
(5 Nhận xét)
5.5
(32 Nhận xét)
5.2
(4 Nhận xét)
5.6
(21 Nhận xét)
5.0
(5 Nhận xét)
4.9
crypthne

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 Thêm

$250 AUD trong 3 ngày
(34 Nhận xét)
4.5
(2 Nhận xét)
4.1
RomanRut

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 Thêm

$750 AUD trong 5 ngày
(8 Nhận xét)
4.1
Crayon1365

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

$650 AUD trong 15 ngày
(7 Nhận xét)
4.2
(2 Nhận xét)
3.9
niarfedevelop

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 trong 7 ngày
(13 Nhận xét)
4.1
nolk

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 Thêm

$400 AUD trong 7 ngày
(7 Nhận xét)
3.4
rjramanayake

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 Thêm

$250 AUD trong 3 ngày
(12 Nhận xét)
3.3
daniyal3214

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 Thêm

$300 AUD trong 1 ngày
(3 Nhận xét)
4.0