how can i put an excel document onto an access database

[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

 

[Tom Wickerath]

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

 

[middletree]

please change your system clock. Now, this message will be at the top in IE
for the next year.

 

[Arvin Meyer]

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

 

[Arvin Meyer]

Set your system time back to 2003! I should have waited a year before

replying!!!

Since it appears that the date was intentionally set to put this on top of
the list, you may just want to PLONK this guy.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Lallin]

how can i put an excel document onto an access database?

your mom

 

[alien2_51]

fix your date

 

[cooler_wu]

how can i put an excel document onto an access database