Trying to "automate" inserting record numbers in Access 2010 query

Hi

Very much a newbie in Access 2010. I have successfully created queries involving a 10 or so record numbers in a large database. I now need to create a query made up of 170+ record numbers per year for 15 years. I am wondering if I can, in some way, import the record numbers from Excel to Access? Otherwise, I will have to type or paste the 170+ record numbers for each year.

Appreciate any suggestions/reading material.tutorials.

Thank you

Al

Hi

Thank you for responding. I am trying to create a query in access 2010. The files that I am working with are very large so itwas recommended that I link to the csv files that I downloaded from the Center for Medicaid Services. I would like to create a query that begins with a record number that pulls a range of data from the Medicare Cost Report. Up till this point, I have entered the record numbers individually followed by other data parameters. My problem is that I want to run a large query so I am wondering if I can use the record numbers that I already have stored in an Excel file. Otherwise, I will have to enter each record number either via cut and past or type them in which will be very time consuming. The out put of this query is a series of data extracted from the various worksheets in the cost report.

Thanks again for offering to help. Is this answer specific enough. I could, I think, attach an access file if that would help you to assist me.

Al

Hi

I realize I haven't given you much of a description so I reread the literature for the data base. So let me try again. The data base is comprised of three tables (1) Report Table containing descriptive information (2) Alpha Table containing character and numeric values (3) Numeric Table containing numbers only. The files are in Excel's csv format. This is a relational data base which, according to the literature, means that the Report Table needs to be linked with either the Alpha or Numeric table depending on the values requested. The linking field is known as the report record number RPT_REC_NUM. The individual RPT_REC_NUM represents one line of data for each organization in the data base which contains of the the numeric and descriptive data for that organization for a given year.

So far, I have been successful in accessing the data base because I have been dealing with a small number or organizations. What I have done is to (1) open a particular year in Access (2) click on Create/Design Query (3) open the Report and Numeric Tables. The first item in each is the RPT_REC_NUM (4) click, drag, connect the RPT_REC_NUM from the Report Table to the Numeric Table. I then type in a record number and a description of the items sought in the query. This is a somewhat time consuming process because I have to retype the record numbers every time (1) I require additional information from the data base and (2) when I make a mistake.

The problem I am trying to overcome is that I would like to query the data base for information on 170+ organizations which means that I, with my current method, would have to enter the RPT_REC_NUM for 170+ organizations for every year of data that I want to retrieve. I understand that there is an alternative method that links a table of record numbers, RPT_REC_NUM, to the Report Table and the Numeric Table used in an inquiry. Currently, I have the record numbers for each year in an Excel file. I think this may be called creating a MakeTable query?

So my questions are (1) is it possible to create a table containing record numbers that can be used over and over again and (2) if yes, can I do this through some import function so that I avoid manual processes?

I hope this description gives you a better idea of what I would like to accomplish.

Thanks again for responding.

Al

Thank you.

Looks like I have my work cut out for me today!

Al

Just a note to say that your help pointed me in the right direction, helping me to think through and SOLVE my problem.

Very helpful contribution