how can i put an excel document onto an access database

  • Thread starter Thread starter Tom Wickerath
  • Start date Start date
T

Tom Wickerath

If you'd like a helpful answer, I'd suggest providing some additional information about
what type of data your Excel spreadsheet contains. Most spreadsheets are not
normalized--they contain data that is related one-to-many (1:M). Give us an idea of the
type of data that you are interested in importing. It is relatively easy to import data
from Excel, but your goal should be to end up with related data, not simply an Access
spreadsheet.

You need to spend some time gaining an understanding of database design and normalization
before attempting to build something in Access (or any RDBMS software for that matter).
Here are some links to get you started. Don't underestimate the importance of gaining a
good understanding of database design. Brew a good pot of coffee and enjoy reading!

http://www.datatexcg.com/Downloads/DatabaseDesignTips1997.pdf

http://www.eade.com/AccessSIG/downloads.htm (See the last download titled "Understanding
Normalization")

http://support.microsoft.com/?id=234208


Tom
_______________________________________


how can i put an excel document onto an access database
 
Set your system time back to 2003! I should have waited a year before replying!!!

_______________________________________


If you'd like a helpful answer, I'd suggest providing some additional information about
what type of data your Excel spreadsheet contains. Most spreadsheets are not
normalized--they contain data that is related one-to-many (1:M). Give us an idea of the
type of data that you are interested in importing. It is relatively easy to import data
from Excel, but your goal should be to end up with related data, not simply an Access
spreadsheet.

You need to spend some time gaining an understanding of database design and normalization
before attempting to build something in Access (or any RDBMS software for that matter).
Here are some links to get you started. Don't underestimate the importance of gaining a
good understanding of database design. Brew a good pot of coffee and enjoy reading!

http://www.datatexcg.com/Downloads/DatabaseDesignTips1997.pdf

http://www.eade.com/AccessSIG/downloads.htm (See the last download titled "Understanding
Normalization")

http://support.microsoft.com/?id=234208


Tom
_______________________________________


how can i put an excel document onto an access database
 
please change your system clock. Now, this message will be at the top in IE
for the next year.
 
There are 3 ways to deal with this, depending upon your version of OE and
your configuration.

1. If you are hiding read messages, just read it.
2. Select and delete the post.
3. Block the Sender (you can re-enable him later if you wish) and answer
"Yes" when you are asked if you'd like to delete his messsages.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Back
Top