SQL Databank article data

Imekamilika Ilichapishwa Miaka 2 iliyopita Kulipwa wakati wa kujifungua
Imekamilika Kulipwa wakati wa kujifungua

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

Kitambulisho cha Mradi: #32628247

Kuhusu mradi

43 mapendekezo Mradi wa mbali Ipo mtandaoni %project.latestActivity_relativeTime|badilisha%

Imetuzwa kwa:

(Maoni 65)
7.2

43 wafanyakazi huru wanazabuni wastani wa €591 kwa kazi hii

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 kwa siku 2
(Maoni 158)
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 Zaidi

€550 EUR kwa siku 7
(Maoni 53)
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] Zaidi

€750 EUR kwa siku 17
(Maoni 6)
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 Zaidi

€720 EUR kwa siku 8
(Maoni 4)
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 Zaidi

€250 EUR kwa siku 7
(Maoni 6)
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, Zaidi

€250 EUR kwa siku 5
(Maoni 13)
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 Zaidi

€500 EUR kwa siku 7
(Maoni 13)
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 kwa siku 15
(Maoni 11)
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 Zaidi

€500 EUR kwa siku 7
(Maoni 1)
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 Zaidi

€500 EUR kwa siku 7
(Maoni 6)
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. Zaidi

€300 EUR kwa siku 7
(Maoni 4)
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 Zaidi

€300 EUR kwa siku 6
(Maoni 5)
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 Zaidi

€500 EUR kwa siku 7
(Maoni 2)
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 Zaidi

€250 EUR kwa siku 2
(Maoni 1)
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 Zaidi

€500 EUR kwa siku 7
(Maoni 0)
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 Zaidi

€500 EUR kwa siku 7
(Maoni 0)
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 Zaidi

€500 EUR kwa siku 7
(Maoni 0)
0.0