Populating Records

[rciolkosz]

I have a downloaded excel report for export into access, the County name is
in cell B1 with the list of cities in C5 through C how ever many. Then
another County name appears a few rows after that to start another batch of
cities. Question is, I need the County name to apear next to the city name
automatically in the access records. Is anything possible to do that?

 

[Larry Linson]

I have a downloaded excel report for export into access,
the County name is in cell B1 with the list of cities in C5
through C how ever many. Then another County name
appears a few rows after that to start another batch of
cities. Question is, I need the County name to apear next
to the city name automatically in the access records.
Is anything possible to do that?

The answer to your question is "Yes, it can be done." The likely other
answer is, "There is not an 'automatic, one-click' way to do it.

With details on the layout of the data -- for example, "list of cities in C5
through C how ever many", and any other data that is also in the
spreadsheet, and blank lines, and how many cities on a line, and how cities
on the same line are separated, and a few other items, and whether the
"excel report" is, in fact, an Excel spreadsheet / worksheet, or a text
file, one could approach _how_ it can be done. That might be as simple as a
combination of manually-performed Excel and Access actions, or a bit more
complex, such as importing in exactly the same format into large text fields
and using VBA code to parse the information into fields in records in Access
tables.

If you'll clarify, I suspect that someone here will be able to offer useful
suggestions.

Larry Linson
Microsoft Office Access MVP

 

[rciolkosz]

It is in excel format. An example is as follows.

Cook County
Chicago
LaGrange

looking for:

Cook County Chicago
Cook County LaGrange