SQL Databank article data
€250-750 EUR
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)
ID Proiect: #32628247
Detalii despre proiect
Acordat lui:
43 freelanceri plasează o ofertă medie de 591€ pentru proiect
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
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
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
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
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
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
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.
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
*****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
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
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
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
⭐⭐⭐⭐⭐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