Manipulating A Flat File for Import in MS Access

Hi,

I have a 'flat'file' in excel that I have been trying to format in order to import in MS Access.

Attached is an example of what I have ...... and what I am trying to achieve.

NOTE : In the real life example there are 1200 rows and 77 columns ....... the attached is a simple example in order to illustrate my point.

I have tried to write code to perform this all day and am now off to bed !

Can anyone here come up with a simpe VBA routine to achieve the attached (which I will then be able to adapt to my real life example).

Many thanks.

Hi,
Try this.
Let me know if you have any questions.
Tony

Thanks.

your example works perfectly, however I cannoty adapt it to my real example !!!! How do i change the ranges in your code ?

My data has;

COLUMN HEADING RANGE A1:E1
NO. OF ROWS OF DATA 1,231
FIELD HEADING RANGE F1:CD1

Thanks.

Got it ...... I was looking for ranges in the code .... realise nowe that you had named ranges on the sheet .... doh !

Thanks ALOT for your help.