By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,940 Members | 614 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,940 IT Pros & Developers. It's quick & easy.

Export access data table into excel

P: n/a
I have a little problem i was wondering if anyone could help. I have
created a table in Access and it has the following format.

UniqueID FieldResult
100 1,3,5,7,23,7,8,9,12,4
103 12,6,,6,4,8,12,10,19

My problem is that i need to export the table into excel and then in
excel the uniqueID should become a column and each value in the
FieldResult section should become a column. e.g.

Col1 col2 col3 col4 col5
100 1 3 5 7 etc.....
103 12 6 6 etc...

Has anyone came across this before i dont have a clue how to comma
delimit the memo field.

Many thanks
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
What version of Access are you using and have you tried format other than
CSV?

--
Travis Cornwell
Computer Science Coop
REM Services Inc.
tw******@ncsu.edu
"Colin Graham" <cs********@hotmail.com> wrote in message
news:ee**************************@posting.google.c om...
I have a little problem i was wondering if anyone could help. I have
created a table in Access and it has the following format.

UniqueID FieldResult
100 1,3,5,7,23,7,8,9,12,4
103 12,6,,6,4,8,12,10,19

My problem is that i need to export the table into excel and then in
excel the uniqueID should become a column and each value in the
FieldResult section should become a column. e.g.

Col1 col2 col3 col4 col5
100 1 3 5 7 etc.....
103 12 6 6 etc...

Has anyone came across this before i dont have a clue how to comma
delimit the memo field.

Many thanks

Nov 12 '05 #2

P: n/a
Im using Access XP, i havent exported the table into any format as
yet, i was wondering if there is code or a tool which i can use to
bring this into excel and sort into the necessary columns.
"Perlith" <pe*****@hotmail.com> wrote in message news:<4V*********************@twister.southeast.rr .com>...
What version of Access are you using and have you tried format other than
CSV?

--
Travis Cornwell
Computer Science Coop
REM Services Inc.
tw******@ncsu.edu
"Colin Graham" <cs********@hotmail.com> wrote in message
news:ee**************************@posting.google.c om...
I have a little problem i was wondering if anyone could help. I have
created a table in Access and it has the following format.

UniqueID FieldResult
100 1,3,5,7,23,7,8,9,12,4
103 12,6,,6,4,8,12,10,19

My problem is that i need to export the table into excel and then in
excel the uniqueID should become a column and each value in the
FieldResult section should become a column. e.g.

Col1 col2 col3 col4 col5
100 1 3 5 7 etc.....
103 12 6 6 etc...

Has anyone came across this before i dont have a clue how to comma
delimit the memo field.

Many thanks

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.