Sedang Disiapkan

Parsing Excel Spreadsheet into Volusion database

Vendors give their prices in an Excel format. Unfortunately they put similar models in one row. To import to Volusion database, I need to parse so that each product has its own row.

For example, in a spreadsheet of hundreds of products, they typically merge multiple types in one row separated by a comma or '/' :

(Delimiter is either comma or '/')

Product Brand Model Color Manufacturer Number

Toner Brother TN-620 DCP-8080DN, DCP-8085DN,etc etc Black M1960G/A

Toner Brother TN-620 DCP-8080DN/DCP-8085DN, Black M1960G/A

I need a script, macro etc to be able to parse multiple items and create new rows for each model, so I can import them into Volusion:

Product Brand Model

Toner Brother TN-620 DCP-8080DN Black M1960G/A

Toner Brother TN-620 DCP-8085DN Black M1960G/A

Toner etc etc Black M1960G/A

It can be done in Excel, Access, SQL etc.

Or if there's another way to import these into Volusion, open to suggestions too.

Kemahiran: Pemprosesan Data, Excel, Microsoft Access, SQL, Volusion

Lihat lebih lanjut: access database volusion, parse spreadsheet access, parse excel database, spreadsheet script, manufacturer prices, excel 16, dcp, volusion excel macro, volusion access, database models, tn, row spreadsheet, macro excel, macro + excel, import excel, excel to sql, excel model, excel format, database in excel format, create spreadsheet, c# import excel, c import excel, create access database spreadsheet, multiple excel, sql merge data excel

Tentang Majikan:
( 2 ulasan ) Temple City, United States

ID Projek: #1536794

Dianugerahkan kepada:

nagybatonyi

Such jobs are my daily practice. If you send me a sample source file I'll make a free pilot conversion for you. Further use of macros, fixing of bugs and minor changes are included in the bid without any additional fee Lagi

$250 USD dalam 2 hari
(45 Ulasan)
5.6

36 pekerja bebas membida secara purata $283 untuk pekerjaan ini

thetechie13

Volusion expert

$250 USD dalam 4 hari
(53 Ulasan)
7.0
rhomeu

MS Access, VBA expert here. This can be done in MS Access. Please check PM Thanks

$250 USD dalam sehari
(42 Ulasan)
6.5
bharanisrihari

Hello, Excel VBA expert here. I've done similar projects. Please check PM for details. Thanks!

$250 USD dalam 2 hari
(59 Ulasan)
6.3
SigmaVisual

We can help in your project, please check PMB and our ratings/reviews to get idea of our experience.

$350 USD dalam 7 hari
(27 Ulasan)
6.0
Teloquence

Excel expert at your service. Check your inbox for details.

$250 USD dalam sehari
(64 Ulasan)
5.5
LK1811

A comma separated values spreadsheet will do. Please let me have the details.

$250 USD dalam 3 hari
(44 Ulasan)
5.5
gshiels

I have 20 years Excel experience and have worked with many different systems, so this is straightforward for me. Please check my feedback and 100% completion rating.

$250 USD dalam 2 hari
(8 Ulasan)
5.1
rapidwebservices

Hi, I have about 6 years experience in Volusion products, categories, options, etc (Volusion Expert). I can done it very well to be able these product to import in Volusion database and without any error. Hoping you wi Lagi

$250 USD dalam sehari
(7 Ulasan)
5.0
ineedWorkJob

Greetings sir, i am an expert freelancer. for this job and your 100% satisfaction is assured if you allow me to serve, for more info please cheek your message box for this project(Private)

$250 USD dalam sehari
(32 Ulasan)
5.0
srinichal

I am an expert in automation and can deliver the script to your needs

$420 USD dalam 5 hari
(9 Ulasan)
4.9
Nhcuong

Hi, An Excel expert at your service! parsing various data file formats an put in backend database is my daily work. I would be glad to do this job for you. Please send me the excel source file as an example and file fo Lagi

$250 USD dalam sehari
(23 Ulasan)
4.9
northwolves

Ready to start,provide more details,please.

$250 USD dalam 3 hari
(38 Ulasan)
4.8
thelogicgates1

Please see pmb.

$250 USD dalam 7 hari
(3 Ulasan)
4.6
hemi

Hi, Please check PMB for workout of proposed project. Thanks

$250 USD dalam 2 hari
(16 Ulasan)
4.5
sigmasolve

Hi, Please check PMB for more details and our portfolio. Thanks.

$250 USD dalam 5 hari
(7 Ulasan)
4.5
momo2619

Dear Sir, Please read your PM. Thanks Meena

$250 USD dalam 0 hari
(12 Ulasan)
3.7
muthumuni

...........#####... "KINDLY FOLLOW MY MASSAGE & FEEL REAL DIFFERENT HERE" ...##### ............

$250 USD dalam 0 hari
(7 Ulasan)
3.6
hardcorefs

Hi, I have recently completed a 'cleanup' on a 750,000 row database

$300 USD dalam 4 hari
(1 Ulasan)
3.3
AccuPro

Can do this.

$250 USD dalam 2 hari
(4 Ulasan)
3.4
richardst

Hello, Sir. How are you? I have over 10 years of excel programming and over 13 years of database programming with sql server ,mysql and volusion. I have carefully looked into your project requirement and i think Lagi

$250 USD dalam 3 hari
(3 Ulasan)
3.2