Conversion the Database

  • Thread starter Jerry via AccessMonster.com
  • Start date
J

Jerry via AccessMonster.com

Hell Im a new into this:

I want to put information into my Microsoft Access Databases, from Microsoft
Except Spreadsheets. In my Spreadsheet, there is over on hundred sheets.
Each of the sheets should be a table inside of Microsoft Access.

I want to bring into Microsoft Access all of my information that is on my
Spreadheets.

Do you no of a better way to happen this into the computer?

Another two question: If I am using Microsoft Access 2003 and I want to send
emails, through it, What type of Computers would I need in my server.
Currently, I have 4 to 5 computers inside of my server, and they each have
over 500 Gigabytes of Storag in it!
 
J

John Vinson

Hell Im a new into this:

I want to put information into my Microsoft Access Databases, from Microsoft
Except Spreadsheets. In my Spreadsheet, there is over on hundred sheets.
Each of the sheets should be a table inside of Microsoft Access.
Click to expand...

No. They should certainly NOT.

Excel is a spreadsheet, a good one. Access is a relational database.
An Access Table may *look* like a spreadsheet BUT IT IS NOT ONE.

Relational databases require quite different logic and structure than
spreadsheets. For example, spreadsheets almost always have
calculations in some cells; tables NEVER do. It's normal to have 100
different spreadsheets (or even different workbooks) for similar data;
it's NEVER a good idea to do so in Access. If you have 100 sets of
similar data you would use *ONE* large table with an additional
indexed field identifying the subsets.
I want to bring into Microsoft Access all of my information that is on my
Spreadheets.

Do you no of a better way to happen this into the computer?
Click to expand...

File... Get External Data... Import will let you import a spreadsheet
into Access; but as noted that's just the start of your work.
Another two question: If I am using Microsoft Access 2003 and I want to send
emails, through it, What type of Computers would I need in my server.
Currently, I have 4 to 5 computers inside of my server, and they each have
over 500 Gigabytes of Storag in it!
Click to expand...

The question is almost meaningless. Access doesn't send email, though
it can work with Outlook (or Outlook Express, or other email programs)
to do so; any hardware that can run both Access and Outlook would be
suitable. You almost surely do not need to buy new hardware.

John W. Vinson[MVP]
 
Top