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 2 5114
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
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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Matt |
last post by:
I have an ASP page that calls ASP routines that I created that execute
a database query and return the results to a recordset. I then iterate
through the recordset and display the data in a table....
|
by: Gary Wright |
last post by:
I have an Access 2K database split into front and back. Quite often the
users want to do some data analysis that I have not created a report for so
they want to export some subset of the data into...
|
by: Anthony Cuttitta Jr. |
last post by:
I'm working on some procedures where Access queries are exported to
Excel, and then later on, those same workbooks are openned, and I need
to target a specific original sheet. Sometimes there will...
|
by: Ellen Manning |
last post by:
I'm trying to export an Excel2K spreadsheet to A2K. Here is a sample
of the Excel spreadsheet:
LastName FirstName Hours Location HoursPercent
Doe John ...
|
by: Keon |
last post by:
Hoi,
I'm using a database with alot of records in 1 table (more than 3000). If i
want to export this table to excel i only get it till record 2385. Do
someone know how i can solve this...
|
by: Hans [DiaGraphIT] |
last post by:
Hi!
I want to export a dataset to an excel file. I found following code on the
net...
( http://www.codeproject.com/csharp/Export.asp )
Excel.ApplicationClass excel = new ApplicationClass();...
|
by: smaczylo |
last post by:
Hello, I've recently been asked to work with Microsoft Access, and
while I feel quite comfortable with Excel, I'm at a complete loss with
databases. If someone could help me with this issue I'm...
|
by: CoolFactor |
last post by:
MY CODE IS NEAR THE BOTTOM
I want to export this Access query into Excel using a command button on an Access form in the following way I describe below.
Below you will find the simple query I am...
|
by: StevoNZ |
last post by:
I've been using Access to export data to Excel all year... this data has been increasing in size as the project nears compleion and now I find that when I export a table (or query) to Excel using the...
|
by: =?Utf-8?B?YzY3NjIyOA==?= |
last post by:
Hi all,
I have a question for you.
I have a .csv file which has many lines of data.
Each line has many data fields which are delimited by ",".
Now I need to extract part of data from this...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
| |