i am using Microsoft Excel and Access. and would like to know if i can do this so to save me a lot of work.
2006-06-12 09:37:57 · 14 answers · asked by eleshiak 2 in Computers & Internet ➔ Software
Yes, there are many ways, if you can't get it to work using everyones answers - send it to me I will convert it for you. zqizzy@yahoo.com
2006-06-12 09:40:23 · answer #1 · answered by zqizzy 3 · 0⤊ 0⤋
I have done this on a Macintosh, using Excel, but not using Access.
You have to
Create the data base file ( name it)
and
set up the data base fields to be in the same order as the spreadsheet fields.
Then you can copy the whole spreadsheet into the data base.
it is worth taking the time to see if you can make it happen.
2006-06-12 16:43:05 · answer #2 · answered by nickipettis 7 · 0⤊ 0⤋
It is possible to import an excel file into access. Just go to access and open the database you want to import the file. Go to FIle, Get external data, import. At the File window, select or browse for the excel file you want to import and change files of type to excel.
2006-06-12 16:48:43 · answer #3 · answered by James T 3 · 0⤊ 0⤋
It sure is. There are several ways.
In Excel, you can use the Export function to create a CSV or Comma Delimited file which can be easily imported into Access. Actually, if I'm not mistaken, Access can even READ XLS (excel) files directly.
2006-06-12 16:45:16 · answer #4 · answered by Anonymous · 0⤊ 0⤋
Go to the Tables tab in Access and right-click. There it will say "Import", then select your Excel spreadsheet and follow the Wizard. That should do it.
2006-06-12 16:40:21 · answer #5 · answered by Anonymous · 0⤊ 0⤋
Yes, you can. But, I don't remember how. I do know that you can go to www.gcflearnfree.org, sign up for FREE, and you can learn all about computer software, how to use it, etc. You can learn by each chapter, or go in succession and receive a certificate at the end. You can do it at your own pace, or take a class.
This is just an idea of where you might find the information you need. Good luck!
2006-06-12 16:46:52 · answer #6 · answered by honey 6 · 0⤊ 0⤋
yeah thats very easy, design a table of the same number of rows in access, then copy the data from the excel sheet and paste it simply in access
2006-06-12 16:43:13 · answer #7 · answered by Haseeb Uddin 2 · 0⤊ 0⤋
go to the file you want to move and highlight itthen right click on the blue highlighted area then left click on copy. go to where you want to put the file the right click in that area and then laft click on paste.
2006-06-12 16:44:36 · answer #8 · answered by Anonymous · 0⤊ 0⤋
As long as your columns and data types match, you can just copy and paste.
2006-06-12 16:43:28 · answer #9 · answered by allknowing 4 · 0⤊ 0⤋
Just copy & paste
2006-06-12 16:40:37 · answer #10 · answered by Joy 1 · 0⤊ 0⤋