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, spreadsheet script, manufacturer prices, excel 16, dcp, volusion excel macro, volusion access, database models, tn, row spreadsheet, macro excel, excel model, excel format, create spreadsheet, create access database spreadsheet, multiple excel, sql merge data excel, excel macro row, excel volusion sql, import data macro excel, need excel format, macro merge rows, excel access import data, excel sql merge, excel sql create

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