Data import from Excel

[iSeven]

Okay, apologies up front for I am not a DBA by any means but I have never had such problems trying to import data in my life, I'm hoping someone here can help me out with this one.

I have an Excel spreadsheet with the following information in each row:
ResponseID, Response1, Response2, Response3,..., Response99

I need to import into an already existing Access table the data from the Excel spreadsheet as follows (each line below basically represents a new entry into the table):

Data from Row 1:
Row1 - ResponseID, Response1
Row1 - ResponseID, Response2
Row1 - ResponseID, Response3
...
Row1 - ResponseID, Response99

Data from Row 2:
Row2 - ResponseID, Response1
Row2 - ResponseID, Response2
Row2 - ResponseID, Response3
...
Row2 - ResponseID, Response99

and so on...

Does this make any sense? I can't for the life of me figure out how to import all of this information. I can, if need be, import this into a SQL DB if it will make any of this easier.

Thanks,
iSeven

 

[WB786]

Open up table in design mode and add the fields as they appear in your Excel spreadsheet. I always like to creat these field in the begining of the table and then move them later if need to. Then just go to file and import function and choose the table you want the data to append to. Always back up your table first before do this. You can also import it into a new table and then copy paste into the table you want. Enjoy.


_WB