If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Importing Question
I am creating a database for credit card payments recv. This is information
is already on a Excel spreadsheet but cannot hold so much data anymore. Can I import this Excel sheet into the Access Database or do I need to create from scratch? Thanks for any assistance. |
#2
|
|||
|
|||
Importing Question
Yes you can import an Excel spreadsheet into Access.
But you should *not* design your Access tables, in the way that you would enter a spreadsheet. You need to learn the topic of "database normalization". Google that term, you'll find lots of articles. HTH, TC (MVP Access) http://tc2.atspace.com |
#3
|
|||
|
|||
Importing Question
On Mon, 03 Apr 2006 16:05:00 GMT, "accessdiscussion" u20433@uwe
wrote: I am creating a database for credit card payments recv. This is information is already on a Excel spreadsheet but cannot hold so much data anymore. Can I import this Excel sheet into the Access Database or do I need to create from scratch? Thanks for any assistance. You can very readily import it: File... Get External Data... Import, and select .xls from the "files of type" dropdown. Note that Access is not "a big version of Excel". Excel is a spreadsheet, best of the genre; Access is a relational database. They are DIFFERENT and require different logic. Just for starters, Excel spreadsheets routinely use calculated values; Access tables cannot, do not, and SHOULD not store calculated values (that's done in Queries instead). So some substantial redesign will need to be done, probably *first* before you start importing data; you can then import the actual data contents into a properly normalized set of Access tables. Check out the links at the Access Junkie's webpage for some hints at how to get started on the mental shift needed: http://home.bendbroadband.com/conrad...resources.html John W. Vinson[MVP] |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Beginner Question - Automation of Importing to Db | Steve | General Discussion | 2 | January 25th, 2006 03:52 PM |
Question about Importing? | Randy | New Users | 2 | July 2nd, 2005 05:57 AM |
importing from excel question. | drewlucas | Calendar | 2 | May 25th, 2005 06:16 PM |
Importing Of Fonts Into Word 2002 Question ? | [email protected] | New Users | 7 | May 24th, 2005 09:09 AM |
database design question | e-mid | Database Design | 9 | June 16th, 2004 09:42 PM |