By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,859 Members | 1,859 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,859 IT Pros & Developers. It's quick & easy.

Converting excel to Access

P: n/a
Hi,

I have to convert an existing spreadsheet for rejects into an access
database. My problem is I use a load of lookup tabels in excel. How do
I approch this in access. Also, just a general question, can you do
pivot tables in access.

Thanks

Feb 6 '06 #1
Share this Question
Share on Google+
3 Replies


P: n/a
On 6 Feb 2006 03:59:13 -0800, "Decreenisi" <cy*********@hotmail.com>
wrote:

Typically the lookup tables become new tables. E.g. tblRejects has
fields ReasonID and ReportedByID. These are linked to tblReasons
(ReasonID, Reason) and tblEmployees (EmployeeID, FirstName, LastName)
etc. In a form where you enter rejects, you offer multi-column
dropdown lists where the user thinks he selects a Reason, but he's
really selecting the hidden ReasonID which is stored in the
tblRejects.ReasonID field.

Pivot tables are called Crosstab queries in Access. There is a wizard
entry when creating a new query, or you can study the Transform
statement.

-Tom.

Hi,

I have to convert an existing spreadsheet for rejects into an access
database. My problem is I use a load of lookup tabels in excel. How do
I approch this in access. Also, just a general question, can you do
pivot tables in access.

Thanks


Feb 6 '06 #2

P: n/a
Holding a different opinion:
On forms, lookups in Excel can often be replaced with combo boxes in
Access. The multi-column dropdowns referred to above are used to fill
text boxes (form fields) using a .column property in Access.

Acess as a relational database, pulls Excel Lookups into a single table
view by using queries that are linked between two or more tables. So,
if your Excel table refers to a customer or product key for rejects,
you can pull fields from the related table into a reject report
directly (without using the dropdown form fields mentioned in the first
paragraph)

Pivot Tables are pivot tables in Access. Access 2003 performs Pivot
Table work in Access, prio versions call to Excel to perform Pivot
Table work.

Remember, Access is a relational database programming language. Once
the data is stored in an access database, you can show, update, and
report in many ways.

Feb 6 '06 #3

P: n/a
On 6 Feb 2006 08:07:01 -0800, "DoDahD" <da****@gmail.com> wrote:

Not sure I fully understand. Are you saying we should have a textbox
*and* a (presumably unbound) dropdown, and then writing some code in
dropdown.afterupdate to set textbox to dropdown.column(x)? What is
the benefit over having a single control: a bound dropdown with a
hidden ID column and a visible Description column?

-Tom.

Holding a different opinion:
On forms, lookups in Excel can often be replaced with combo boxes in
Access. The multi-column dropdowns referred to above are used to fill
text boxes (form fields) using a .column property in Access.

<clip>

Feb 7 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.