Creating an Access form(s) based on an Excel Workbook

[r.peachey]

Hi,

I need to create a set of forms in Access 2002/2003 based on a workbook
in Excel 2002.

The workbook consists of a set of spreadsheets which perform a water
quality index calculation. Is there any way to directly import or
convert the spreadsheets into forms and intergrate the VB coding into
to the new forms or will I have to start from scratch??

Any help would be appreciated

 

[Guest]

Generally speaking, it is difficult to go directly from Excel to Access.
Since Access is a relational database as opposed to a spreadsheet, the format
is quite different. For example, you probably have some columns which
contain repetitive information. In Access you would build a table, where
that information is listed only once, and a key is used to refer to those
values from another table. In addition, many of the column headings in Excel
will become entries in a field, which are then referred to by their key.

So, if you really need to transfer this data to Access, you will need to
build all of your tables first, making sure that they are properly
normalized, before you even begin transferring your data over. And then you
will have to normalize your data before you transfer it. Once that is done,
then you can create your queries, tables, and reports to massage that data
into the form you need it in.

 

[PCD]

You can create Access tables that link to a worksheet or ranges in a work
sheet then build Access forms based on the tables. Any changes you make to
the data in the forms will automatically change the data in the worksheets.
You can also use Access to Excel automation where you would enter data in
Access forms and that data would be written to specified cells in a
specified worksheet.

 

[StopThisAdvertising]

"PCD" <[email protected]> schreef in bericht
--

PC Datasheet
Your Resource For Help With Access, Excel And Word Applications 'Resource ????
Over 1150 users have come to me from the newsgroups requesting help '1150 users ????
(e-mail address removed)

--
To Steve:
Over 550!! users from the newsgroups have visited the website to read what kind of a 'resource' you are... (rapidly increasing..)

To the original poster:

Most people here have a common belief that the newsgroups are for *free exchange of information*.
But Steve is a notorious job hunter in these groups, always trying to sell his services.

Before you intend to do business with him look at:
http://home.tiscali.nl/arracom/whoissteve.html

Arno R

 

[PCD]

You are an obsessed, egocentric A$$!!! You don't contribute anything to our
newsgroup but you revel in wasting your time tracking all my responses to
posters in the newsgroups. Take the advise that was given to you and grow up
and get a life. Get lost! We don't need you in our newsgroups!!!

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
Over 1150 users have come to me from the newsgroups requesting help
(e-mail address removed)




"PCD" <[email protected]> schreef in bericht

--

PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
'Resource ????
Over 1150 users have come to me from the newsgroups requesting help
'1150 users ????
(e-mail address removed)

--
To Steve:
Over 550!! users from the newsgroups have visited the website to read what
kind of a 'resource' you are... (rapidly increasing..)

To the original poster:

Most people here have a common belief that the newsgroups are for *free
exchange of information*.
But Steve is a notorious job hunter in these groups, always trying to sell
his services.

Before you intend to do business with him look at:
http://home.tiscali.nl/arracom/whoissteve.html

Arno R

 

[Guest]

Steve,

You can create Access tables that link to a worksheet or ranges in a work
sheet then build Access forms based on the tables. Any changes you make to
the data in the forms will automatically change the data in the worksheets.

Not if the user has installed the latest service packs for Office. The
ability to save a change in a linked Excel spreadsheet was recently
eliminated in later versions of Access, due to a court ruling that did not go
in Microsoft's favor. For example, you can edit linked Excel data in Access
2003, as long as you only have SP-1 installed. Do the upgrade to SP-2, and
your linked spreadsheets are all of a sudden read only.


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[Guest]

Steve,

If you'd just change your signature to read:

PC Datasheet
www.pcdatasheet.com

and eliminate the rest, I'm pretty sure that Arno would let up on his
relentless campaign against you.


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[TC]

Arno, this campaign may be appropriate in CDMA, but IMHO, it is not
necessarily appropriate in the MS newsgroups.

The difference between CDMA, and these MS newsgroups, is the relative
absence of flame wars here.

Personally, I'd like to keep it that way!

Just my 2c.

Cheers,
TC (MVP Access)
http://tc2.atspace.com

 

[PCD]

Tom,

Thanks for the heads-up!! I did not know that. If you link to Excel data,
can you still run queries on the Access tables?

Steve

 

[Guest]

Hi Steve,

If I understand your question correctly, the answer is yes. The linked Excel
data will behave as a read only table. You can still use this table in your
queries. You just cannot run an update or append query against it. I haven't
tested whether you can delete records from a linked Excel spreadsheet. My
guess is that it is read only.


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[PCD]

Thanks, Tom!

Hi Steve,

If I understand your question correctly, the answer is yes. The linked
Excel
data will behave as a read only table. You can still use this table in
your
queries. You just cannot run an update or append query against it. I
haven't
tested whether you can delete records from a linked Excel spreadsheet. My
guess is that it is read only.


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[StopThisAdvertising]

Steve,

If you'd just change your signature to read:

PC Datasheet
www.pcdatasheet.com

and eliminate the rest, I'm pretty sure that Arno would let up on his
relentless campaign against you.


Tom

Me and my goons would stop this campaign immediately indeed.

Arno R

 

[PCD]

Even your goons have abandoned you lately, you A$$!!!!! All you are doing is
showing every newsgroup reader what an A$$ you are!!!!

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
Over 1150 users have come to me from the newsgroups requesting help
(e-mail address removed)

Steve,

If you'd just change your signature to read:

PC Datasheet
www.pcdatasheet.com

and eliminate the rest, I'm pretty sure that Arno would let up on his
relentless campaign against you.


Tom

Me and my goons would stop this campaign immediately indeed.

Arno R