In access, how do I enter an excel speadsheet that you can create.

L

LBX2G

I am creating a database for a customer and they want several headings that
will have sub headings and data attached. They want to be able to run
queries off any part of the data, but I have no idea how to create this using
access. I thought you might be able to change a table entry into an excel
spreadsheet, but it doesn't seem that you will be able to run queries from
this. Can anyone help?
 
D

Dave M

Can you give an example of what's required? It sounds as though you need a
grouped report and a form to select filtering criteria, but it's not clear.
 
L

LBX2G

I have created a table with all the headings I want on each input form. For
example one of the headings is called 'PSTN', then under that heading I need
six fields, Provider, Number of Users, Contract Value, Contract Expiry,
Service Quality and Other Comments. We need to be able to enter data into
those fields on the input form, but in a way that means you can still run a
query on those entries. The queries might just be on the first field i.e
'Provider' or it might be on on the whole 'PSTN' heading and the infomation
contained within it. Is it possible to do this? Thanks.
 
J

John Vinson

I am creating a database for a customer and they want several headings that
will have sub headings and data attached. They want to be able to run
queries off any part of the data, but I have no idea how to create this using
access. I thought you might be able to change a table entry into an excel
spreadsheet, but it doesn't seem that you will be able to run queries from
this. Can anyone help?
Click to expand...

Excel is a spreadsheet, a good one. Access is a relational database.
THEY ARE DIFFERENT. You can drive nails with a crescent wrench, but
that doesn't make it a hammer!

You can use File... Get External Data... Import or File... Export to
import or export the *data* in an Access Table or Query to a
spreadsheet; or you can use File... Get External Data... Link to link
to a spreadsheet; this will let Access see the data which exists in
Excel, update it, run queries based upon it, and so on.


John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Top