recreate database

[Mark G.]

I want to convert an existing excel database to an access database for more
control and abilities when uploading as a webpage. The existing excel
spreadsheet has several sheets within a workbook with each sheet containing
various columns that reference items in other sheets and within it's own
sheet. Can anyone please take the time to tell me the best method for this
and the do's and don't and whatnot and maybe also point me to a location for
more info? Have tried a little on my own with not much good results. Any
help would be much appreciated. Thanks much.

 

[John Vinson]

I want to convert an existing excel database to an access database for more
control and abilities when uploading as a webpage. The existing excel
spreadsheet has several sheets within a workbook with each sheet containing
various columns that reference items in other sheets and within it's own
sheet. Can anyone please take the time to tell me the best method for this
and the do's and don't and whatnot and maybe also point me to a location for
more info? Have tried a little on my own with not much good results. Any
help would be much appreciated. Thanks much.

The first thing to realize is that Access and Excel are VERY DIFFERENT
PROGRAMS. Access is *not* a bigger and better version of Excel!

You'll almost surely need to do a pretty thorough redesign. The first
step will be to "normalize" your table structure (see the links below,
especially the Database Design 101 links in Jeff's page). Cell
references will need to all be replaced with Queries joining tables;
Forms will need to be rebuilt from scratch; calculated fields will
need to be moved out of Tables ("sheets") and into Queries, just for a
few examples. It's not trivial, but from the sound of it it's a good
way to go nonetheless.

Jeff Conrad's resources page:
http://home.bendbroadband.com/conradsystems/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

John W. Vinson[MVP]

 

[Mark G.]

I know a lot more about excel than I do access but feel that access is the
way to go with this. With that said, can anyone recommend any step by step
procedures specifically for this? See, I noticed that there is an import and
export function for both functions and it does work to a degree, but some
things do not stick and as mentioned, with some things, you pretty much got
to redo it. The links are pretty helpful and insightful, thanks for them.

 

[aaron.kempf]

Excel isnt' a fucking database

Excel is for fucking retards that can't read a WHOLE BOOK

lose the training wheels; Excel is for FIRST GRADERS

take a couple of classes; read a half-dozen books

there is no easy way to make up for the past decade that you were
jerking off to Microsoft Excel. Excel is a waste of time and your
so-called 'Excel Skillset' is close to WORTHLESS.

-Aaron

 

[aaron.kempf]

Excel isnt' a fucking database

Excel is for fucking retards that can't read a WHOLE BOOK

lose the training wheels; Excel is for FIRST GRADERS

take a couple of classes; read a half-dozen books

there is no easy way to make up for the past decade that you were
jerking off to Microsoft Excel. Excel is a waste of time and your
so-called 'Excel Skillset' is close to WORTHLESS.

-Aaron