Importing Question

[accessdiscussion]

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.

 

[TC]

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

 

[John Vinson]

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/conradsystems/accessjunkie/resources.html

John W. Vinson[MVP]