Transfer of data from excel to Access /Access to Excel

[shalskedar]

In the excel sheet attached below can the particular data b transfered to Access.

The data is more of the dimensions data i.e the tabular data in the sheet has to go to Access...Based on the data various other Reports can b generated...



Plz let me know how to transfer this data from various sheets to Access...

[Megalog]

Have you tried a regular Excel Import??

In Access 2007, go to the External Data tab, and under the Import grouping click Excel. Then let the wizard walk you through all the steps. You can either link to the sheet as a linked table, append the data to a pre-existing table, or create a new table. Then set how your data is delimited, whether the first row is the header for the table, etc..

Play with this and then if you have any specific questions come on back.

[shalskedar]

Thanks..I tried out the Import option but still the data can't be transfered in a proper way..

Can u Plz help me with attaching my Excel Worksheet here so that u can 've an idea abt what exactly i want....