Update this excel import

[Maarkr]

I've imported data from an excel ss that looks like this:

Org A 5 Z
7 M
1 K
Org B 5 N
3 L
1 K
Org C 4 W

So, a field with the org, that is only filled in on the first line but
applies to the empty lines below it, then a number field (all filled), then
a txt field (all filled). Any ideas how I can update the org into the empty
fields or do any kind of update query to use the data assigned to that org?
OTHER THAN CUT/PASTE? thanx

 

[ND Pard]

It would be much easier to correct it in Excel before importing it into Access.

Assume your "OrgA" starts in column A on row 6 and the last row for "OrgC"
is in column A row 20.

Hi-Lite cells A6 through A20.
Press your "F5" function key.
Click "Special..."
Check "Blanks"
Click "OK"

Now in cell A7, which is where you should be if you followed the preceding
steps, enter +A6 ... but rather than just hitting Enter ... hold down the
Control (Ctrl) Key and then hit Enter. This should fill in all of the blank
cells with data from above.

Then, again hi-lite the cells A6 through A20, copy them, Right-Click on any
of the Hi-Lited cells, select "Paste Special", check "Values" and click "OK".

Now all of your rows will be filled as you requested. Save the file.

Finally, goto Access and import the desired data.

Good Luck.

 

[Jeanette Cunningham]

Maarkr,
The data looks like a one to many relationship.
A table for Org and a separate for the other 2 fields.
It is awkward data because the Org value is only specified for some records.
Is this a one off import?
Are there heaps of records?
Do you have access to the spreadsheet where you could fill in the null
values in the spreadsheet?

If you want to automate the import, you could open a recordset on the
imported data and row by row append it to the appropriate tables (one table
for Org and a related table for the other 2 fields).

Jeanette Cunningham