 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / July 2006Coverting Rows in Fields
I am trying to import data from MS Access but it comes as rows i excel. Is it possible to while we importing the database into the excel we change the rows to columns and data still get synce with databas source. lets say fields a1 b1 c1 d1 data a2 b2 c2 d2 a1 a2 b1 b2 c1 c2 d1 d2 Regards, A Select all the data (fields and data), right click and choose "Copy", Right click in top left cell of new location (*no* overlap), Choose "Paste Special", And click "Transpose". You could also paste to another sheet if necessary.  SignatureHTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- > > I am trying to import data from MS Access but it comes as rows in [quoted text clipped - 13 lines] > Regards, > AJ Thank You, I am doing for Database when ever new record will enter to the Access. i will not show in that situation in the Excel. I already done it. Is there any other solutions. Regards THank again AJ Signaturekhansab143 I overlooked the request in your OP to "sync" the data. Does this work for you? Say you import to Sheet1. Try this on Sheet2, where you can enter this formula in any cell: =INDEX(Sheet1!$A:$AA,COLUMNS($A:A),ROWS($1:1)) Then, copy across, and then copy down. I've set the index range for 27 columns ( A:AA ), Which allows you to copy down 27 rows, and across unlimited columns. If your original data extends beyond Column AA, just adjust that in the formula. Of course, the max is 256 rows down if the index range goes to A:IV. SignatureHTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- > Thank You, > [quoted text clipped - 5 lines] > Regards > THank again AJ
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.