473,320 Members | 2,073 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Converting excel to Access

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
3 2373
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
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: John | last post by:
I'd love to hear some expert opinion on my situation. My department relies on Excel as a database, which causes crashing due to resource depleting and basically is just too slow. For example, a...
2
by: Richard Sherratt | last post by:
The system is an Access 97 front end to a SQL Server back end. There's a whole heap of VBA code. It has its own secure workgroup MDW. It uses automation to open and modify Word, Excel, and...
4
by: M. Uppal | last post by:
How do i convert fraction to time in c#. I need to convert 0.25 to time. Excel does this by using Selection.NumberFormat = "h:mm:ss;@" of the Cell Format function. thanks, M. Uppal
1
by: Ramakrishnan Nagarajan | last post by:
Hi, I am converting Excel data into a Dataset in C#. There are around 24 columns in the Excel Sheet. First I tried to insert one row with correct values in the Excel sheet. i.e. for text columns...
1
by: UKuser | last post by:
Hi Guys, I have a program which converts Excel spreadsheets to Javascript and allows interactivity. However it can't convert it to PHP, which is obviously better for users to view (in case J/S...
5
by: Testguy | last post by:
Hi, I was wondering if one the smart people that frequent this group could give me a hand with a small program I am attempting to debug. I am not a highly experienced developer, but can...
1
by: ShailShin | last post by:
Hi All, I have to convert Excel data to MSAcess .MDB file using VB.NET. VB.NET Code read the Excel file and write it to .MDB file. For the same I have below code, but I am stuck at the writing it...
8
by: Michael B. Trausch | last post by:
I was wondering if anyone has had any experience with this. Someone I know is trying to move away from Microsoft Works, and I am trying to look into a solution that would convert their data in a...
1
by: PW | last post by:
Hi, When I run the following command, some fields are ending up blank when the clearly have values them in Excel. I have tried converting the columns to general and text. The ones that are...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.