Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
How to count rows in Excel before importing into Access?
Thanks PHV and Skip, both of your suggestions do indeed work great! Such an easy result for such a lengthy headache =D. Many thanks to the responses here. Have a good one. -Tethys- Tethys
- Post #10
- Forum: Microsoft: Access Modules (VBA Coding)
-
How to count rows in Excel before importing into Access?
I don't know how many cells in any given column (column B, for instance) have data. If column B were my ID column, and it were always populated, counting each cell in this column will give me the row count I am after. I'll give COUNT or COUNTA a shot. Perhaps I'm not implementing Range...- Tethys
- Post #7
- Forum: Microsoft: Access Modules (VBA Coding)
-
How to count rows in Excel before importing into Access?
Oh, heh...*sigh* I do seem to be able to count every row now...and I suppose that is what that line is trying to do. What I'd LIKE to do, though, is only count those rows that have data in them. That is where I was hoping to lead the above question to. If it helps any, column B will always...- Tethys
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
-
How to count rows in Excel before importing into Access?
Hi everyone. I've an issue needing some help. I am trying to count the number of rows in a worksheet before copying the data over into an Access table. What I've tried so far is giving me an overflow issue - which makes me wonder if I'm just counting every single row in the worksheet...- Tethys
- Thread
- Replies: 9
- Forum: Microsoft: Access Modules (VBA Coding)
