Cut & paste limitation

J

jwm

I'm in the process of migrating a large amount of text into a new research
database. I thought I could simply copy & paste the text into the
appropriate fields, however, Access seems to choke at some point with too
much text on the clipboard.

Does anyone have any ideas as to how to speed up the process.

As the information is textual and presently arranged in chapters, there
isn't any good (as far as I can see) delimiter to use in an import function.

TIA.
 
J

Jeff Boyce

It sounds, from your description, as if you are copying large blocks of text
into (hmmm, must be) memo fields in an Access database. Have you considered
using a simple, small field 'typed' as a hyperlink data type? Then you'd
only need to "point" to where your current document is located...

Just a thought...

Jeff Boyce
<Access MVP>
 
J

John Vinson

Does anyone have any ideas as to how to speed up the process.
Click to expand...

An Append query, or (possibly) parsing the text using VBA code and
appending it, will be preferable if they're feasible.
As the information is textual and presently arranged in chapters, there
isn't any good (as far as I can see) delimiter to use in an import function.
Click to expand...

Blanks? NewLine characters? ANYTHING? What's the structure of the text
file, and of the table into which you wish to append it? Have you
tried File... Get External Data... Import, using the wizard?

John W. Vinson[MVP]
 
J

jwm

Thanks for the replies...I think I'll go with a link to the text files as
they are all over the 65K character limit of the memo field type...didn't
know that until I began the project.

Happy Holidays...
 
Top