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

--
khansab14
-----------------------------------------------------------------------
khansab143's Profile: http://www.excelforum.com/member.php...fo&userid=3640
View this thread: http://www.excelforum.com/showthread.php?threadid=56183

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.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"khansab143" <(E-Mail Removed)> wrote
in message news:(E-Mail Removed)...
>
> I am trying to import data from MS Access but it comes as rows in
> 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 database
> source.
>
> lets say fields a1 b1 c1 d1
> data a2 b2 c2 d2
>
> a1 a2
> b1 b2
> c1 c2
> d1 d2
>
>
> Regards,
> AJ
>
>
> --
> khansab143
> ------------------------------------------------------------------------
> khansab143's Profile:
http://www.excelforum.com/member.php...o&userid=36409
> View this thread: http://www.excelforum.com/showthread...hreadid=561832
>

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


--
khansab143
------------------------------------------------------------------------
khansab143's Profile: http://www.excelforum.com/member.php...o&userid=36409
View this thread: http://www.excelforum.com/showthread...hreadid=561832

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.

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"khansab143" <(E-Mail Removed)> wrote
in message news:(E-Mail Removed)...
>
> 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
>
>
> --
> khansab143
> ------------------------------------------------------------------------
> khansab143's Profile:
http://www.excelforum.com/member.php...o&userid=36409
> View this thread: http://www.excelforum.com/showthread...hreadid=561832
>