how to; transfer a data base from excel to access office 2003 stu

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I recorded an assignment in Excel and I should have done it in Access. Does
anyone out there know how to transfer the whole thing to Access. I have till
the end of the day to accomplish this or my grade will bejepordized
tremendously.
PPlease HHelp!

ricki racer
 
Access's facilities for storing and processing data are fundamentally
different from Excel's, so for anything more than the simplest
worksheet, "transferring the whole thing" is a complicated business.

But it is usually easy to import data from Excel to Access by using the
latter's File|Get External Data|Import menu command. Just about
everything else will have to be re-created using Access's own tools, and
database concepts rather than spreadsheet ones.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can I transfer data from Excel to Access dBase 1
RTF data from Excel 2007 to Access 2007 1
How to export table from outlook into ms access table? 0
Transfer Spreadsheet in Access 2007 1
I have excel 2003 and received a XLSX file and can't open it How? 2
create a comma delimited transfer file from one data base to anoth 1
Export Data from an access table to a pre-formatted excel template 1
transfer my data from a memory stick(excel) to microsoft access? 1

Back
Top