Hi,
I have an access DB with a table with a set of 60+ fields for my eCommerce platform. I then have multiple xls/csv files which I wish to import into this table. To make things easier I will start with one xls file. These are the field names: Product Number, Manufacturer Number, Category, Manufacturer, Description, EAN and more.
I have setup the table which has compulsory fields which are set as required, some fields need default data so I have setup this also.
I need to import the xls file which I currently have linked, into the table for my eCommerce. What I need to figure out is how to import this, map the fields as they do not match between the xls and the table. I also need to be able to fill some fields in with a combination of fields two or more fields and some we need to input some standard text into the fields of the DB table. Please see some examples below:
XLS Fields DB Table
EAN (Example: 45678) SKU = EAN The EAN will also include some standard text to end result will look like the example (Example: "ad-sp-45678")
Manufacturer (Example: Apple) Meta _Keywords = Manufacturer & Category with comma between (example: "Apple, Laptop")
Category (Example: Laptop)
I have also attached screen shots of the fields
Any advice would be mich appreciated.
Thanks
Martyn