Excel Table to Access Records

**GBR2L** · 11-25-2010, 12:08 PM

Hi,

I have an excel table with 10000 rows and 5 columns and I'm looking for a way of creating a record for each row - column combination which would give me 50,000 rows which I could import into an access database.

Can anyone suggest the besdt way of doing this

Thanks

GBR2L

**KiPA** · 11-25-2010, 03:24 PM

Hmmm. Did I misunderstood or didn't you want every possible combination? Amount of that would be rather 5^10000 (quite a lot) than 50000.

**GBR2L** · 11-26-2010, 06:05 AM

Hi,

Thanks, no for the first row I what to generate five records, one for each column of data hence the 50,000 records in total

GBR2L

**AnnK** · 12-10-2010, 04:59 PM

I don't know if you're still working on this....
What sort of data are we talking about? Is the data across the columns related at all or are you just talking about a simple list that you have set up in columns in order to not have to scroll forever to look at your data?