VBA module for importing excel data

[gangu]

I have an excel sheet where the first five columns are unique/fixed (A:I) then after that ranges J:V, W:AI, AJ:AV, AW:BI, BJ:BV…….PJV contain similar data that I would like to import in a new record in an access database table while maintaining AI for each range that is added in the database, right now I have a module for importing the entire db, how can I modify this so that I can split the excel rows as different records in the access table.
i.e each record in the database should appear like this

A:I, J:V
A:I, W:AI
A:I, AJ:AV
..
.. e.tc.
How can I achieve this, have a tight dealine in a few hours time
Thanks for your help.

 

[Mihail]

While this thread
http://bytes.com/topic/access/answe...stomized-export-data-access-excel#post3711321
is a help for you, I don't think that is an option for someone that is under time pressure.

Try to manage data in Excel.
A bit of VBA will put the splitted rows in a new sheet.

 

[gangu]

Thanks a bunch let me look at this.....will let you know how it goes

Gives me this error on opening the form frmImport

The expression On Open you entered as the event property setting produced the following error: The code in this project must be updated for use on 64-bit systems. Please review and update Declare statements and then mark them withthe PtrdSafe attribute