Access Table Help Please...

[Scott LaPointe]

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!

 

[Smart]

You could try importing the excel spreadsheet into your database
File , get external data , import