Need to map excel feilds to access database ASAP (will pay $ for help)

[Steven Thibault]

I have an excel file of product inventory with about 400 rows and 20 columns. The columns contain pricing, description, shipping method, etc...



We use a program called blackthorne to list our products on ebay. It uses an access database. I want to simply link the excel file data into the access dtb. Currently we're having to manually enter the data from the excel file into blackthorne and it's time consuming.

I can email both files if anyone wants to have a look.. I will paypal you fair pay for your help.

[RuralGuy]

Linking or importing an Excel file is really very easy. You can do it yourself in minutes.

[Steven Thibault]

That doesn't really help.

[RuralGuy]

We can take this off line if you want.

[Steven Thibault]

We can take this off line if you want.

I'll send you the files but I think its going to be a little more difficult than what you're anticipating. The dtb file is uploading (160mb), will be a few minutes.

[RuralGuy]

It usually is but we'll know when I get them. Still it does not sound too difficult. Just be sure and include some directions as to what you need.

[Steven Thibault]

I highlighted the columns (orange) in the xls file that need to be linked/imported into the access database. Once you open the access file, it should be apparent what I'm trying to do.

[RuralGuy]

I'll let you know when the file(s) arrive.

[RuralGuy]

Let me know in this thread when you have sent the files and I'll be on the lookout for them.

[RuralGuy]

Have you sent them yet? I still do not have anything.

[RuralGuy]

I highlighted the columns (orange) in the xls file that need to be linked/imported into the access database. Once you open the access file, it should be apparent what I'm trying to do.

I'm afraid I can not figure out a couple of issues:
1) What columns go into what tables?
2) How do you syncronize the db with the Excel sheet? What rows go where?

[Steven Thibault]

From the Access database the information we want to add is located in "ITEMS" > Fixed price, description, image URL, etc..

[RuralGuy]

Does the new spreadsheet *replace* the existing table or append to it? Is the spreadsheet *always* in this same format?

[Steven Thibault]

it appends.. if it was a straight transport it would be easy.. thats the problem. I dont know how to make it append and sync with all the other data.

[Steven Thibault]

if you can figure it out i'll paypal you 50 because we do this constantly from vendor excels.