Microsoft Office

Microsoft Office Questions? Ask a IT Expert for Support ASAP

Ask a Computer Expert,
Get an Answer ASAP!

Microsoft Office

I need a 3 excel spreadsheets converted to a single MS

Customer Question
access database, can you do...
I need a 3 excel spreadsheets converted to a single MS access database, can you do this?
Submitted: 1 year ago.Category: Microsoft Office
Show More
Show Less
Ask Your Own Microsoft Office Question
Answered in 6 minutes by:
8/3/2016
Microsoft Office Technician: Jason Jones, Computer Technician replied 1 year ago
Jason Jones
Jason Jones, Computer Technician
Category: Microsoft Office
Satisfied Customers: 16,918
Experience: Over 10 years work experience.
Verified

Hello,

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,

Jason

Ask Your Own Microsoft Office Question
Customer reply replied 1 year ago
OK, ill upload the spreadsheets, but i need some advice on creating the database, I want to basically have a single place to store all my customer info, including their purchase history. So to keep the fields manageable, i read that separate tables could be used for say, customer name and addess, email, phone, and another table for customer ID, purchased equipment, etc, and these can be made relational, is this still within your scope?
Customer reply replied 1 year ago
Lastly, I want this to be collaborative for 5 - users, ( we have been attempting to do this with excel and dropbox, which is less than ideal) so either Office 365 or using OneDrive to host the back end files
Customer reply replied 1 year ago
We basically have 3-4 people who are constantly adding and editing these sheets, so I hope to avoid conflict by using a database rather then excel + dropbox, to make it possible for multiple users to edit simultaneously ( not the same record obviously) not sure the difference between all the MS options in this regards,
Microsoft Office Technician: Jason Jones, Computer Technician replied 1 year ago

Thank you for the clarification. Once I receive the documents, I will begin.

Ask Your Own Microsoft Office Question
Customer reply replied 1 year ago
I uploaded them both ( only 2 not 3) 30 min ago, I can send a dropbox link if you did not get them
Microsoft Office Technician: Jason Jones, Computer Technician replied 1 year ago

Hello,

You have to give me the download links. I do not see the downloads links on this page.

Thank you,

Jason

Ask Your Own Microsoft Office Question
Customer reply replied 1 year ago
8
Microsoft Office Technician: Jason Jones, Computer Technician replied 1 year ago

I see two excel documents. Was there only two or were there three?

Ask Your Own Microsoft Office Question
Microsoft Office Technician: Jason Jones, Computer Technician replied 1 year ago

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.

Ask Your Own Microsoft Office Question
Customer reply replied 1 year ago
the tabs on the document INTERNAL are just to separate out the different customer types, based on customer ID, which made it easier to sort through when using Excel, the tabs can go away on that spreadsheet
Customer reply replied 1 year ago
The other shreadsheet I will split up, its basically customer name , email and mailing address, combined wiht billing info, the billing info should be a separate database table but linked, the same with the tab called sharefile, let me sort that out first
Microsoft Office Technician: Jason Jones, Computer Technician replied 1 year ago

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.

Ask Your Own Microsoft Office Question
Customer reply replied 1 year ago
Not confidential, but I'd rather the customer contact information not be made public or shared, but it's not PII in any way, shall I unshare those?
Microsoft Office Technician: Jason Jones, Computer Technician replied 1 year ago

Yes, please unshare them as I have already downloaded them.

Ask Your Own Microsoft Office Question
Customer reply replied 1 year ago
OK doing that now, I am re-doing the second database with all the customer contact info as well, to remove duplicated fields or un-needed info, so please wait on that one.
Microsoft Office Technician: Jason Jones, Computer Technician replied 1 year ago

Thank you.

Ask Your Own Microsoft Office Question
Customer reply replied 1 year ago
Hi Jason, Im ready with the other spreadhseets if you are avialable
Microsoft Office Technician: Jason Jones, Computer Technician replied 1 year ago

Yes, I am available.

Ask Your Own Microsoft Office Question
Customer reply replied 1 year ago
Hi Jason, firedrill for another project, im going to have to wait until Monday, but I can upload at least one or two other spreadsheets tomorrow, woudl you prefer to do this on Monday ?
Microsoft Office Technician: Jason Jones, Computer Technician replied 1 year ago

Hello,

I work seven days a week, everyday, so we can continue on Monday or your choice of time.

-Jason

Ask Your Own Microsoft Office Question
Customer reply replied 1 year ago
Hi JasonI finally have the excel spreadsheets up to date, there are 2 of them, can I upload them some place, then have you take a look and make some recommendations on setting them up as the starting point for an Access database, we are using the Office 365 version of Access and want to host the back -end in the cloud so multiple people can work on it
Microsoft Office Technician: Jason Jones, Computer Technician replied 1 year ago

Hello,

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"

Ask Your Own Microsoft Office Question
Customer reply replied 1 year ago
I just discovered a few more errors I need to correct, will send tomorrow, sorry for the fire drill, also is there a secure way I can send you the files, such as ShareFile, where I can control the times downloaded?
Microsoft Office Technician: Jason Jones, Computer Technician replied 1 year ago

Thank you

Ask Your Own Microsoft Office Question
Customer reply replied 1 year ago
Hi Jason, I have the spreadsheet, can I send you a link to download it?
Microsoft Office Technician: Jason Jones, Computer Technician replied 1 year ago

Yes, please.

Ask Your Own Microsoft Office Question
Customer reply replied 1 year ago
Here is the ShareFile link,https://aidd.sharefile.com/d-sb6890cf551f41cfa
Microsoft Office Technician: Jason Jones, Computer Technician replied 1 year ago

Thank you. I have the document. Please, explain to me now what exactly you need done to this document.

Ask Your Own Microsoft Office Question
Microsoft Office Technician: Jason Jones, Computer Technician replied 1 year ago

If this document has any confidential information in it, please remove it from the server.

Ask Your Own Microsoft Office Question
Customer reply replied 1 year ago
I want to use this as the base table to start an Access database for all our customer data, the anchor points are the customer numbers and the license keys- you helped us create them about 6 months ago - we have another spreadsheet that has detailed customer info - addresses , email etc. I want to be able to add other tables to this, but right now we are in the process up changing a lot of the KEY information on this sheet, and it is impossible to do on DropBox with Excel, since only one person can work on it at a time, hence, in Access we cal collaborate. There are tabs in this just to help us keep organized but other than the notes, all the tabs should be about the same. I guess can you look this over and tell me if there are any problems with the way we have it organized to add more tables later with additional infomation
Microsoft Office Technician: Jason Jones, Computer Technician replied 1 year ago

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?

Ask Your Own Microsoft Office Question
Customer reply replied 1 year ago
Could you do that, and add the following 2nd spread sheet as a table in the same database,This is the detailed customer infohttps://aidd.sharefile.com/d-sf8e992e02544e5eb
Customer reply replied 1 year ago
One last thing, I just checked, on the tab 'customers that have not replaced' on INTERNAL the columns should have the same headings as the tab 'replacement keys,
Name Customer # Original Key Replacement Key Please note any actions herethe most important being Column E is Original Key and column F is Replacement Key
Microsoft Office Technician: Jason Jones, Computer Technician replied 1 year ago

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.

- Jason

Ask Your Own Microsoft Office Question
Microsoft Office Technician: The-PC-Guy, Computer Manager replied 1 year ago
The-PC-Guy
The-PC-Guy, Computer Manager
Category: Microsoft Office
Satisfied Customers: 2,038
Experience: 20 years experience providing remote computer support
Verified

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.

Ask Your Own Microsoft Office Question
Customer reply replied 1 year ago
Hi jasonwhat happened? I thought you could do this?
Microsoft Office Technician: The-PC-Guy, Computer Manager replied 1 year ago

my name is ***** *****

as i said

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.

Ask Your Own Microsoft Office Question
Customer reply replied 1 year ago
Hi PC guy, thanks for taking over, I was not aware of the additional charges, I will have to check first so please bear with me
Microsoft Office Technician: The-PC-Guy, Computer Manager replied 1 year ago

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.

Ask Your Own Microsoft Office Question
Customer reply replied 1 year ago
OK we are good, I can send you the ShareFile link to look at the two spreadsheets I want to start with, I can probably firgure out the rest as I go along - got the book - but I just want to make sure the initial inport is correctIn the Excel sheet - Database, if there is any info that needs to be split up - like first name, last name, address, can you help set that up too? There will be a few more tables that I will want to import and add later but these two are the start
Customer reply replied 1 year ago
Here are the fileshttps://aidd.sharefile.com/d-s59da3a70ade419bb
Customer reply replied 1 year ago
Im going to be AFK for 30-40 min, can you take a look at the files and let me know then, and I can answer any other questions that you might have?
Customer reply replied 1 year ago
Hi are you still there?
Microsoft Office Technician: The-PC-Guy, Computer Manager replied 1 year ago

looked that the link, but it says there are no files.

Ask Your Own Microsoft Office Question
Customer reply replied 1 year ago
Sorry I forgot to upload them, they are there nowhttps://aidd.sharefile.com/d-s1fe3bc9512c440fb
Microsoft Office Technician: The-PC-Guy, Computer Manager replied 1 year ago

ok, got the files, so please tell me what you want this DB to do

Ask Your Own Microsoft Office Question
Customer reply replied 1 year ago
THis will be the start of our CRM database, customer names, numbers, license keys, emails, update type, and eventually equipment typeThe 'anchor points' are the customer Codes and License Keys, each system that uses our software has a unique key and that is how we need to track them.These two spreadsheets are the start, I want to be be able to add more tables in the future
Microsoft Office Technician: The-PC-Guy, Computer Manager replied 1 year ago

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.

Ask Your Own Microsoft Office Question
Customer reply replied 1 year ago
All the tabs are there just to make look up easier, they sort the types of customers. Here is a photo of how I whiteboarded the desired end result. 75% of our customers only have one system/one key. the rest have multiples. I will need a column added to the INTERNAL sheet, next to the customer code, that is SYS, which will serve to differentiate which system for a given customer has which key, the values in this will be something like PC1 or TAB1 ( PC or Tablet)So Customer Name - CAS-001 --TAB1 -- (key)The column with Current Key - Replacement key is only important for the next 3-4 weeks ( and why I need the database ) since as you can see, a large number of our customers are getting their old keys replaced and trying to keep track of this using excel and dropbox is not working - once all the old keys have been replaced, I will delete that extra column - but for now I need itAs we replace the keys, if a customer had a replacement key, we have been cutting and pasting the replacement into the current key column, so if there is no replacement, it means either it has already been replaced of did not need to be.
Microsoft Office Technician: The-PC-Guy, Computer Manager replied 1 year ago

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.

Ask Your Own Microsoft Office Question
Customer reply replied 1 year ago
Ultimate goal is to STOP using excel for this and just have everyone use Access, I will create web forms, I just want to make sure there are no conflicts or issues when I initially set up the database, I want to be able to add tables later with more info, all tied to the customer number, but want to be able to look up things, like addresses and emails, by customer nameWont need the 1-many as we hope to get granular enough to have a value for SYSTEM, like, PC1 or TAB3, after the customer code, each with a unique key
Microsoft Office Technician: The-PC-Guy, Computer Manager replied 1 year ago

so this is going to be web based? Not just in access?

Ask Your Own Microsoft Office Question
Customer reply replied 1 year ago
I plan to host the .mdb file in either Dropbox or OneDrive and allow multiple tech support clients with Access locally to edit, and with a web form for the sales team
Microsoft Office Technician: The-PC-Guy, Computer Manager replied 1 year ago

ok, my appoligies. Since I am totally lost at this point, I will open your question to others.

Ask Your Own Microsoft Office Question
Customer reply replied 1 year ago
Forget the comment, yes, web based
Microsoft Office Technician: Bruce Wilner,
 replied 1 year ago
Bruce Wilner
Category: Microsoft Office
Satisfied Customers: 77
Experience: principal at Network Security Labortories Inc.
Verified

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?

Ask Your Own Microsoft Office Question
Ask NewITZone Your Own Question
NewITZone
NewITZone
NewITZone, Computer Enthusiast
Category: Microsoft Office
Satisfied Customers: 90
90 Satisfied Customers
Experience: I have been using Office Pro for 10 years and implemented applications for business use.

NewITZone is online now

A new question is answered every 9 seconds

How JustAnswer works:

  • Ask an ExpertExperts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional AnswerVia email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • 100% Satisfaction GuaranteeRate the answer you receive.

JustAnswer in the News:

Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.

What Customers are Saying:

My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed.

One Happy CustomerNew York

Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help.

Mary C.Freshfield, Liverpool, UK

This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!!

AlexLos Angeles, CA

Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult.

GPHesperia, CA

I couldn't be more satisfied! This is the site I will always come to when I need a second opinion.

JustinKernersville, NC

Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around.

EstherWoodstock, NY

Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know.

RobinElkton, Maryland

< Previous | Next >

Meet the Experts:

jstinehelfer

jstinehelfer

Information Systems Manager

36 satisfied customers

A+ Comptia Certified computer repair

JasonJames122

JasonJames122

Computer Enthusiast

0 satisfied customers

I manage all information systems (network of Windows PC's and servers with Microsoft Office products) for a small business

Jess M.

Jess M.

Computer Support Specialist

684 satisfied customers

Computer Software Specialist for more than 10 years

The-PC-Guy

The-PC-Guy

Computer Manager

2,038 satisfied customers

20 years experience providing remote computer support

James K.

James K.

Consultant

260 satisfied customers

Technical Director of IT Company

IT Miro

IT Miro

Computer Scientist

156 satisfied customers

Bachelor's Degree in Information Technology, Microsoft Certified Professional

Chris L.

Chris L.

Support Specialist

143 satisfied customers

Certified Expert with over 10 years experience.

< Previous | Next >

Related Microsoft Office Questions
I have changed server and I am unable to access my account.
I have changed server and I am unable to access my account. Need to reset my password. … read more
Jess M.
Jess M.
Computer Support Specialist
Bachelor's Degree
684 satisfied customers
I purchased a computer several years ago from Staples which
I purchased a computer several years ago from Staples which installed Microsoft office. However, they did not give me the disk it was automatically installed in the computer. The computer crashed and … read more
Cody
Cody
Computer Science
1,468 satisfied customers
I need to reload my Office Home and Business 2016 where do I
I need to reload my Office Home and Business 2016 where do I need to go to download and enter my product key? … read more
Richard
Richard
IT Manager
IT Manager, Consultant
3,214 satisfied customers
I purchased Office 365 yesterday and need to migrate from
I purchased Office 365 yesterday and need to migrate from mail into outlook all my emails can you assist with this … read more
bbao
bbao
Freelance IT Consultant
74 satisfied customers
Just put in new Hard- drive. I have an icon on the screen
just put in new Hard- drive. I have an icon on the screen for OUTLOOK but no connection to the internet. If I wish I can get my e-mail through google but it is a long arduous task. How do I fix it, th… read more
Jess M.
Jess M.
Computer Support Specialist
Bachelor's Degree
684 satisfied customers
Is there any chance Microsoft will stop converting files to
Is there any chance Microsoft will stop converting files to "Read Only" in Excel. This is a very frustrating part of Excel. … read more
UranIT
UranIT
IT Consultant, Network and System Admin
Associate Degree
470 satisfied customers
Received error code 25521 when installing. Alot. Few months
few months ago. removed all previous versions of office … read more
Jess M.
Jess M.
Computer Support Specialist
Bachelor's Degree
684 satisfied customers
I am using MS Word 2010. I need help setting up a template
I am using MS Word 2010. I need help setting up a template for a legal pleading with 26 numbered lines per page and a vertical double line between the numbers and the main body of the text. … read more
Jess M.
Jess M.
Computer Support Specialist
Bachelor's Degree
684 satisfied customers
Have a Word document that I need to make into a template but
Have a Word document that I need to make into a template but want the header editable too - currently this is losing its formatting when placing into a header, whilst keeping it's edit-ability. Additi… read more
bbao
bbao
Freelance IT Consultant
74 satisfied customers
I am trying to sign in to my Microsoft account...
I am trying to sign in to my Microsoft account...***@******.*** … read more
UranIT
UranIT
IT Consultant, Network and System Admin
Associate Degree
470 satisfied customers
I mistakenling uninstall microsoft office. Can I recover it?
I mistakenling uninstall microsoft office. Can I recover it? … read more
Viet - Computer Tech
Viet - Computer Tech
Computer Technican
Bachelor\u0027s Degree
952 satisfied customers
I have an 8 column spreadsheet. A-H. Sorry, I hit enter too
Sorry, I hit enter too early. Excel. Not sure of the version … read more
The-PC-Guy
The-PC-Guy
Computer Manager
2,038 satisfied customers
I am coinstantly getting calls that say they are from
I am coinstantly getting calls that say they are from Microsoft....I have others also trying to call about my computer. How do I know if it is really a call from Microsoft. They are always saying my c… read more
Jess M.
Jess M.
Computer Support Specialist
Bachelor's Degree
684 satisfied customers
I have bought a new Windows 10 and have used my Office 365
I have bought a new Windows 10 and have used my Office 365 sub to install Office suite. I now get a message for me to fix my account in order to continue using the software. What do I need to do? … read more
Cody
Cody
Computer Science
1,468 satisfied customers
Uninstalled office 2011 for mac and then reinstalled from
uninstalled office 2011 for mac and then reinstalled from disk and outlook email not showing up … read more
Damian Costa
Damian Costa
Owner
Computer Network System Engineer
40 satisfied customers
I bought a microsoft office package on 18th Nov. for $99,
I bought a microsoft office package on 18th Nov. for $99, and it hasn't been re cognised on my computer. How doI activate it? … read more
Michelle
Michelle
Manager operations
Bachelor\u0027s Degree
1,273 satisfied customers
I need to re-activate my Microsoft Office and Student 2007,
I need to re-activate my Microsoft Office and Student 2007, after HD being transferred to another computer … read more
Richard
Richard
IT Manager
IT Manager, Consultant
3,214 satisfied customers
My computer just crashed. I had it repaired, but lost
My computer just crashed. I had it repaired, but lost Microsoft Office. I purchased it in December of 2015 off the internet. I do not remember my password ***** reinstall it. Can you help? … read more
P. Kumar
P. Kumar
Information Systems Manager
Bachelor's Degree
380 satisfied customers
Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Show MoreShow Less

Ask Your Question

x