Excel to access

S

Solo

Hi

I have 300 excel files.Now i want them to be maintained as database. I have
tried to import them but my first COLUMN A in excel are the headers not the
first ROW.
how do i transfer the data into access. or if there is any other database
that can be used to import the data.


Solo
 
I

Ian AFFS

Solo,
I don't understand what you mean completely but try using the 'transpose' function in you spreadsheet before you convert into access. Use the help function and type in transpose function it will explain it all there. Hope this helps.
Ian
 
J

john

Select All, Copy, create a new book, select a region n columns x m rows where n is the rows in the original excel and m is the columns in the original file and then Paste Special and check the Transpose checkbox.
It should do the job.
 
J

Jamie Collins

Thanks Joseph, Your post triggered me into remembering 'Transpose' is
a worksheet function. I was looking in MSDN's VBA help!

Jamie.

--
 
Top