473,508 Members | 2,312 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

pasting multiple lines in MS Access

I am interested in creating a database of my mp3 files. What I am looking
to do is paste a series of lines of text into a series of table cells in
access. Every time I try to do it, it pastes ALL the lines of text into ONE
cell.

Any suggestions?

thanks
Nov 13 '05 #1
4 2320
"John Doe" <bi***********@email.com> wrote in message
news:Xn****************@63.240.76.16...
I am interested in creating a database of my mp3 files. What I am looking
to do is paste a series of lines of text into a series of table cells in
access. Every time I try to do it, it pastes ALL the lines of text into ONE
cell.


You might try pasting into Excel and importing that into Access.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Nov 13 '05 #2
John Doe wrote:
I am interested in creating a database of my mp3 files. What I am looking
to do is paste a series of lines of text into a series of table cells in
access. Every time I try to do it, it pastes ALL the lines of text into ONE
cell.

Any suggestions?
An example of your code may be of use.

thanks

Nov 13 '05 #3
I don't know what code you would be referring to. Did I mention I am new at
all this? :)

Thanks


An example of your code may be of use.

thanks


Nov 13 '05 #4
I will give this a shot. I figured the two programs probably were capable
of interacting with one another in this fashion.

Thank you!


You might try pasting into Excel and importing that into Access.


Nov 13 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
4707
by: Jeremy | last post by:
I have a pretty straightforward database that is designed to record free-form information about products (date, source and a memo field). This is searched and updated via a form. For new records,...
3
2279
by: Mike | last post by:
Using MS Access XP standard install (no Jet or MDAC updates applied yet) as front end, MySQL 4.0 as backend and MySQL ODBC connector version 3.51. When pasting multiple records into the database...
9
2754
by: Graham | last post by:
I have been having some fun learning and using the new Controls and methods in .Net 2.0 which will make my life in the future easier and faster. Specifically the new databinding practises and...
6
4960
by: James Radke | last post by:
Hello, I have a multithreaded windows NT service application (vb.net 2003) that I am working on (my first one), which reads a message queue and creates multiple threads to perform the processing...
4
5435
by: lesperancer | last post by:
I have 3 tables (office97) tblQuote quoteNbr tblDetails ( quote : 1 <-> M: quoteDetails) quoteNbr detailLine product value
9
7655
by: Regnab | last post by:
I've got a text box that I want users to paste a list of values into (from Excel for example). However, breaking this large string down into its component records is a little harder. I've used...
13
2910
by: Henry Townsend | last post by:
I hope this is on-topic in c.l.c - it's about the C preprocessor more than the language per se, more generally about the K&R behavior, and most specifically about the Sun cpp which is why I've...
3
1691
by: Bobby | last post by:
Hi, I have an application which uses Access 2003 as both the FE and the BE. However, for a number of good reasons, I am in the process of converting the BE to SQL server 2003. I am not converting...
0
1268
by: Terry Reedy | last post by:
Gabriel Genellina wrote: You can paste a multi-line statement and it gets executed. You can paste in more, and the first may be executed, but anything after is ignored. I presume you are...
0
7123
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...
0
7326
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
7383
jinu1996
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...
0
5627
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
1
5053
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
4707
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
3194
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
1557
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
1
766
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.