elbastador
New Member
- Joined
- Oct 7, 2005
- Messages
- 36
I'm importing some text files into Access. Some of the rows are missing data and I'm trying to copy the value from the row above into all the blank rows. I know I can do this in Excel but I'm trying to figure out how to do it in Access, as some of the files are too large to be imported into Excel. So essentially if I have a table with 3 columns (1st being an autonumber) like this:
1 1 35010
2
3
4 2 35015
5
6
End result is that I would like this:
1 1 35010
2 1 35010
3 1 35010
4 2 35015
5 2 35015
6 2 35015
Is something like this even possible? I'm thinking that I could do something like this in VB, but I'm not as familiar with VB in Access as I am in Excel so I'm not sure how I would set that up. Any thoughts? Thanks!
1 1 35010
2
3
4 2 35015
5
6
End result is that I would like this:
1 1 35010
2 1 35010
3 1 35010
4 2 35015
5 2 35015
6 2 35015
Is something like this even possible? I'm thinking that I could do something like this in VB, but I'm not as familiar with VB in Access as I am in Excel so I'm not sure how I would set that up. Any thoughts? Thanks!