Custom Import from Excel to Access

[rrrt]

Hi,

I am new to using Access 2007 and i would appreciate help regarding importing data from excel to Access.

My Excel spreadsheet's format is as follows:

Name	Group NO	SSN
Name 1	1	SSN Number
Name 2	1	SSN Number
Name 3	1	SSN Number
Name 4	2	SSN Number
Name 5	2	SSN Number
Name 6	3	SSN Number
Name 7	4	SSN Number

and so on...


My Access table format is as follows (how i would like my information to appear on Access):

Group NO (Primary Key Autonumber)	1-Name	1-SSN	2-Name	2-SSN	3-Name	3-SSN
1	Name1	(SSN Number)	Name 2	(SSN Number)	Name 3	(SSN Number)
2	Name4	(SSN Number)	Name 5	(SSN Number)
3	Name6	(SSN Number)
4	Name7	(SSN Number)

How can i import the information So that the group number from the excel sheet corresponds to the record number on the Access Table. Also, listing out the Name and their SSN to the corresponding columns for each group number.
Any help would be greatly appreciated and thank you for lending me your knowledge.

[June7]

The arrangement you want is non-normalized structure. Why is this necessary?

You could import the data as is from the Excel then use code in Access to rearrange the data.

Regardless, this will require complex VBA code to accomplish. Review: http://forums.aspfree.com/microsoft-...ry-322123.html