Importing to an existing database

[fortunman]

I am new to access and I was wondering if anyone can direct me to some help
with importing excel worksheets that I receive weekly into an acess 2007
database that I have already set up and imported one sheet into? Thanks.

 

[Jeff Boyce]

If you've only "imported one {Excel} sheet into" an Access database, you may
be committing spreadsheet on Access. You will not gain the advantages of
Access' relationally-oriented features/functions if you feed it 'sheet data.

Have you normalized your data and built tables in Access to store the
normalized data? Are you importing 'raw' data from Excel, then using
'normalizing' queries to parse it into the appropriate Access tables? You
can pay now or pay later<g>!

Good luck!

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

 

[susan roads]

If you've only "imported one {Excel} sheet into" an Access database, you
may
be committing spreadsheet on Access. You will not gain the advantages of
Access' relationally-oriented features/functions if you feed it 'sheet
data.

Have you normalized your data and built tables in Access to store the
normalized data? Are you importing 'raw' data from Excel, then using
'normalizing' queries to parse it into the appropriate Access tables? You
can pay now or pay later<g>!

Good luck!

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/