Yes, I can most definitely do this for you. May I ask for the Excel spreadsheets to be uploaded?
Please, upload it on the following page and give me the link or just upload it on this page: http://www.megafileupload.com/
Thank you for the clarification. Once I receive the documents, I will begin.
You have to give me the download links. I do not see the downloads links on this page.
I see two excel documents. Was there only two or were there three?
There are a multitude of different tabs in the documents. Which tabs/sheets do you want import into the MS Access Database and how do you want the database setup? Please, give me a few examples.
Is there confidential information on those documents? The license key item appears as though it may be. Please, unshare the Dropbox documents, if they are confidential.
Yes, please unshare them as I have already downloaded them.
Yes, I am available.
I work seven days a week, everyday, so we can continue on Monday or your choice of time.
Please, upload the documents.
Please, be forewarned that the site is not secure:- Click the following link: http://www.wikisend.com- Upload the file to that website- Once it is uploaded, the resulting page will display a "File ID" number.- Please, give me that "File ID Number"
Thank you. I have the document. Please, explain to me now what exactly you need done to this document.
If this document has any confidential information in it, please remove it from the server.
As it stands, your data looks well organized and for this reason, you shouldn't have any issues importing the data into an access database. At this point, what do you want me to do with this? Do you want me to create the access database for you and import the data?
I am sorry, but I will not be able to do this for you.
For this reason, I am opting out of the question and allowing another expert the chance to help.
The next expert will see all that is on this page, so there will be no need to repeat anything.
When another expert picks this up, you will be notified by email.
Thank you for your patience.
hi, i see the last person you were working with was unable to help.
Since I do not have any of the files, I will need to see those to be able to help.
Also note I do charge additional fees @$75 per 1/2 hour. I do not know how long this might take until I see the data and what you want to do.
Please have some patience you may have to re-explain a few things.
Now I am going to assume that once the DB is set up, you will only import this information once, and then when you get it all in access start adding any new information directly in the DB skipping excel all together. The reason for this is that the importing depending on how the tables are set up can be quite complicated.
also for collaboration, remember that even though the db is shared that only one person can work on any given table at a time as access locks it when someone is working on it, and it will only become available once that person closes it.
my name is ***** *****
as i said
ok, no problem.
The additional charges would just be to compensate me for my time. And of course the original cost of the question would be deducted from that total.
Anyway, just get back to me when you are ready to proceed.
looked that the link, but it says there are no files.
ok, got the files, so please tell me what you want this DB to do
i'm looking at the data and I am a little confused. I assume you would have 1 table of customer information, then another table of keys,
but I am not entirely sure how they relate, it seams from the data that the same info is on like 10 different sheets, or maybe it is different names, I didn't look at it too carefuly.
But you have 2 columns current and new key. Does this mean you want to have 2 columns in the DB, or does this need to keep track of all keys historically for example if customer A has 10 keys there would need to be another table that would list all 10 of customer As keys.
so what is the ultimate functionality going to be.
You just want to set up a bunch of tables and manipulate data in excel?
Do you want to have entry forms in the db?
are you going to need to create reports?
The way I see this happening, is you will have one table for customer data. With some kind of customer ID#, if you do not already have ID#s for each customer maybe we do autonumber.
Then a second table for keys, that is a 1-many. So each customer can have 1 key or 10 thousand it doesn't matter. If you want to keep track of the most recent, then maybe a timestamp field, then setup a report that will select only the most recent date for each customer.
As far as updating the old keys with new keys, we could set up a query to do that, It would be best to wait until you have changed them all though, then run the query once.
so this is going to be web based? Not just in access?
ok, my appoligies. Since I am totally lost at this point, I will open your question to others.
I can do this for you.
However, there's no magic wand to wave.
I first have to have a good look at your spreadsheets so as to understand what you're trying to make permanent and how such things are related to one another.
I presume what you're looking for is table definitions, ideally a script that with automatically create and populate your new Access database?