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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: SusanPedersen
- Order by date
-
how to convert columns of data to individual records
I should also mention that there are over 1,000 schools. I know I need to loop through the recordset, but what is throwing me is the fact the the data is "Sparse" -- not all of the schools have all of the 30 fields of data.- SusanPedersen
- Post #6
- Forum: VBA Visual Basic for Applications (Microsoft)
-
how to convert columns of data to individual records
This is going to be an access database and doesn't need to be linked to Excel at all. I'm intrigued by MajP's solution (no code), but you must know that there are 30 potential fields of data, not just the 4 I've used in the example. People who answer Forum questions rule!- SusanPedersen
- Post #5
- Forum: VBA Visual Basic for Applications (Microsoft)
-
how to convert columns of data to individual records
I have some data that looks like this: School1 Address 325 High Street School1 City Dallas School1 State TX School1 Zip 75001 School2 Address 995 E 2nd St School2 City Memphis School2 State TN School3 Address East 42nd St. School3 City New...- SusanPedersen
- Thread
- Replies: 10
- Forum: VBA Visual Basic for Applications (Microsoft)
