SQL Databank article data

Finalizat Postat la acum 2 ani S-au achitat serviciile după ce au fost prestate
Finalizat S-au achitat serviciile după ce au fost prestate

we received a file from our supplier with the latest article data. On table 2 there are links to table 1 providing more information about the articles. We need some of this informtion, such as article material to be able to import the data into our web shop. Can you you create this for us?

The supplier tells us:

the data are all about the 5-digit F&R style number or the 9-digit F&R article number

linkable or linked to each other.

Since I am not familiar with Excel, I would not do this in Excel.

I would import all worksheets into Access as a table. Before doing this, please always delete the first line in the Excel file.

Then create the other required columns in the table structure.

You can then use update queries to update the data from the other tables.

For the update query, you only need to set the correct link to the tables

Alternatively, you can use a make table query.

After the link has been set correctly, you can export all data / each column as you need it.

However, a large number of data record entries are created very quickly in the flat format, which can be exported as CSV.

Here in the case with all the characteristics only for the German language, around 9.2 million.

If I also take the certificates with me, that's 6 more records, around 54,000,000.

Note only for the language de.

____________

e ned this additional information in worksheet 1

Material

Certifications (oekotex, fairwear....). I fmore than one, then use " ;, " in between in one cell

Sleeve lenght (long sleeve, short slevee...)

Washing instructions

PArtner articles (matching aricles eg matching women jacket to men jacket)

SQL MySQL

ID Proiect: #32628247

Detalii despre proiect

43 propuneri Proiect la distanță Activ acum 2 ani

Acordat lui:

(65 Recenzii)
7.2

43 freelanceri plasează o ofertă medie de 591€ pentru proiect

nixtech

Hello Sir Can we discuss more in detail about data extraction? I am willing to start right away Please check my profile for work and experience. Regards Hardeep

€600 EUR în 2 zile
(158 recenzii)
6.8
divumanocha

Hello, Thanks for reviewing my application. I analyze job requirements for a SQL Databank, So I am well familiar with the requirements and will surely help you in this project and I'm able to start right now. I am al Mai multe

€550 EUR în 7 zile
(53 recenzii)
6.8
ayesha0124

Hi there, How u doing? I have came across ur project and i believe i can help u with it as i have great working experience in MySQL and SQL. Please have a look at my portfolio to see reviews and more: [login to view URL] Mai multe

€750 EUR în 17 zile
(6 recenzii)
5.4
sundevmar

Hallo, Vielen Dank, dass Sie die Anforderung Ihres Projekts geteilt haben. Wir lesen Ihre Anforderung und wir verstehen sie. Um mehr zu verstehen und unsere Zweifel zu klären, möchten wir mit Ihnen sprechen. Senden Mai multe

€720 EUR în 8 zile
(4 recenzii)
5.0
VBAautomation

Hi, I hope you are doing well I am a professional on SQL server, VBA programming, MS access and also in power BI. I am doing this job since 2010. I can handle your project in a very prudent manner. Give me a chance s Mai multe

€250 EUR în 7 zile
(6 recenzii)
4.7
parmartanu10

I can start immediately My name is ‘Tanu ’’’’’’’ I have read your job (SQL Databank article data ) I'm a professional Web developer with more than 6 Years experience in php, laravel, woocommerce, wordpress, vue js, Mai multe

€250 EUR în 5 zile
(13 recenzii)
4.6
rayyankabir

Hello, I am the expert on SQL server, Excel, Microsoft Access and also in Power BI. I am also very skilled freelancer who completes his job with 100% client satisfaction. I have also profound knowledge in other sector Mai multe

€500 EUR în 7 zile
(13 recenzii)
4.8
bizmanas

Hi I have 15 years of experience in SQL server Database development. I will be able to help you with the project. please ping me offline to discuss further. I have extensive experience in SQL query tuning.

€778 EUR în 15 zile
(11 recenzii)
4.2
neverkanyamakina

I have experience in -MQL5 and MQL4 for MT5 and MT4 -Convert Strategy to Expert Advisors , Indicators - Whatsapp , Facebook , Instagram Chatbot -Website Development -CMS such Joomla , Wordpress , Mangeto , Drupal Mai multe

€500 EUR în 7 zile
(1 părere)
3.4
aap31374

I have more than 15 years of experience in SQL Server database modelling, design, development, and Administration. I have worked for database designing and modelling of complex business an efficient way. I have very g Mai multe

€500 EUR în 7 zile
(6 recenzii)
3.3
RomanMatveev1

*****SQL EXPERT***** It is my great honor to read your project requirement and place my bid. I am sql and Access expert and have enough experience. I want to make a good friendship with you. I will wait for your reply. Mai multe

€300 EUR în 7 zile
(4 recenzii)
2.8
hussainmuzammal4

what you will provide at that cost? and how we can use it? how we can hide from getting from while scrapping? ❤ Hello Mate ❤ Asalam-o-Alaikum ,I read the information carefully,I understand your requirement,I am Ava Mai multe

€300 EUR în 6 zile
(5 recenzii)
4.8
sultanovilvircr

Hi, Thank you for your job posting! I am a senior web developer with extensive experience developing web applications in multiple languages such as PHP, Node.js, Python, etc. I will guarantee the highest quality and sa Mai multe

€500 EUR în 7 zile
(2 recenzii)
1.6
abdf2010

Hi, It is easy, I can do on time. I work online, where you can track progress of your project. I have 6 years of experience in development(websites, web applications, mobile apps, desktop applications, I/UX), using PHP Mai multe

€250 EUR în 2 zile
(1 părere)
3.1
besidovskaoleole

Hello, Recently, I have worked on a Windows server & Docker & PHP7 & MariaDB project and it was successful job. As you indicated, I will analyze current system and set all properly. I need server access to start worki Mai multe

€500 EUR în 7 zile
(0 recenzii)
0.0
wahid542

Hi I am database developer i read your statement and check attached document along with that . After clear understanding of your document i am bidding here for the services. Please contact me i can provide you required Mai multe

€500 EUR în 7 zile
(0 recenzii)
0.0
dejanmilutinovi1

⭐⭐⭐⭐⭐Hello, How are you? I hope you are doing well.⭐⭐⭐⭐⭐ I'm a Professional Full Stack Developer, and I have 8+ years of experience with Frontend & Backend Development & Amazon web service. My Strong Experiences are a Mai multe

€500 EUR în 7 zile
(0 recenzii)
0.0