how to use excel (or text) file as input to a query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a database in which i wish to allow users to submit a flat file to
submit their information, as opposed to entering a series of answers to
prompts.

Example: Suppose the database consists of toy-related information, and one
of the fields is "toy type", where it could be a train/car/stuffed
animal/book/blocks/etc/etc. The query I've designed allows the user to enter
multiple toy types by prompting for "Toy Type 1", "Toy Type 2", up to a total
10 toy types. However, I'd prefer to have the user submit an excel (or flat)
file. The flat file would allow the user to simply type in up to 10 toy
types in an excel file (or could be a text file if it's easier to work with).


My question is: How do I write a query of my toy database to use the excel
(or text) file submitted by the user ?

(Note: I've tried to simplify my example for the sake of not complicating
things. Also, I would prefer if possible to keep this as a query solution,
as opposed to using forms to solve the problem....but if that's the only way
to go....guess I'll have to learn that too!)
 
Ok, so suppose I can link to the Excel file.....how do I use a query to
"cycle through" the excel file and use the contents of the excel file as an
INPUT to my query (as described below) ?
 
Back
Top