crosmill
Registered User.
- Local time
- Today, 13:27
- Joined
- Sep 20, 2001
- Messages
- 285
i have a db that imports excel files, due to [my] poor design of the spreadsheets some of the records will be imported with missing data, but the data will be on the line just above it.
when all the spreadshhets come back I'm expecting about 50 odd, I'd rather have a way of updating it in access, rather than updating each spreadsheet.
I've sorted out keeping the records ordered so that I can update it from the previous record, but I don't know if there is an easier way of updating from the previous record other than creating recordsets in code building the query that way.
Any ideas would be greatly appreciated.
when all the spreadshhets come back I'm expecting about 50 odd, I'd rather have a way of updating it in access, rather than updating each spreadsheet.
I've sorted out keeping the records ordered so that I can update it from the previous record, but I don't know if there is an easier way of updating from the previous record other than creating recordsets in code building the query that way.
Any ideas would be greatly appreciated.
