EXPORT EXCEL ROWS: CREATE ACCESS QUERY

A

amywolfie

Is it possible to export rows in MS-Excel so that they become Access
queries?

I have an Excel spreadsheet with various field names and data. Each
row would represent a separate query in Access.

Thanks!

====
 
N

Nikos Yannacopoulos

Amy,

It looks like you are not very clear on what you are trying to
achieve... the normal thing to do would be to export Excel data into an
Access table - more accurately, to import Excel data into an Access
table (the operation is actually performed on the Access side).
In Access, a query is an object which selects (or performs actions on)
particular data, often applying some criteria. So, in plain English, a
query would be something like
"Get the names and addresses of all employees in Marketing"
which tells Access (or any database app, for that matter) what to
retrieve (names and addresses of employees), from where (Employees
table) and with what criteria (in Marketing), while it does not hold any
data itself, the data is stored in the table(s).
With the above in mind, "Each row would represent a separate query in
Access" doesn't make much sense.
Care to rephrase?

Nikos
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top