Scott LaPointe
New member
- Local time
- Today, 09:02
- Joined
- May 2, 2006
- Messages
- 5
Found this site on google, looks pretty good, hope you can help me.
I need to update some data but am at a loss on how to do it.
Here is my data...
Column1......... Colum2..... Colum3
Name 1 .......... 1:30 ........ 2:30
...................... 2:30 ........ 3:30
...................... 3:30 ........ 4:30
Name 2 .......... 1:30 ........ 2:30
...................... 2:30 ........ 3:30
...................... 3:30 ........ 4:30
Name 3 .......... 1:30 ........ 2:30
...................... 2:30 ........ 3:30
...................... 3:30 ........ 4:30
basically I need to copy the Name 1 to each of the rows under it so the new data should look like this it originates from an Excel spreadsheet and I need to bring it into an Access Database.
Column1......... Colum2..... Colum3
Name 1 .......... 1:30 ........ 2:30
Name 1........... 2:30 ........ 3:30
Name 1........... 3:30 ........ 4:30
Name 2 .......... 1:30 ........ 2:30
Name 2........... 2:30 ........ 3:30
Name 2........... 3:30 ........ 4:30
Name 3 .......... 1:30 ........ 2:30
Name 3........... 2:30 ........ 3:30
Name 3........... 3:30 ........ 4:30
any help or ides would be appreceated.
Thanks!
I need to update some data but am at a loss on how to do it.
Here is my data...
Column1......... Colum2..... Colum3
Name 1 .......... 1:30 ........ 2:30
...................... 2:30 ........ 3:30
...................... 3:30 ........ 4:30
Name 2 .......... 1:30 ........ 2:30
...................... 2:30 ........ 3:30
...................... 3:30 ........ 4:30
Name 3 .......... 1:30 ........ 2:30
...................... 2:30 ........ 3:30
...................... 3:30 ........ 4:30
basically I need to copy the Name 1 to each of the rows under it so the new data should look like this it originates from an Excel spreadsheet and I need to bring it into an Access Database.
Column1......... Colum2..... Colum3
Name 1 .......... 1:30 ........ 2:30
Name 1........... 2:30 ........ 3:30
Name 1........... 3:30 ........ 4:30
Name 2 .......... 1:30 ........ 2:30
Name 2........... 2:30 ........ 3:30
Name 2........... 3:30 ........ 4:30
Name 3 .......... 1:30 ........ 2:30
Name 3........... 2:30 ........ 3:30
Name 3........... 3:30 ........ 4:30
any help or ides would be appreceated.
Thanks!