 |
AppletTalk.com
Java discussions newsgroups
|
| View previous topic :: View next topic |
| Author |
Message |
Sharp
Guest
|
 Posted: Mon May 23, 2005 8:11 am Post subject: Java and MS Access |
 |
|
Hi
I'm trying to convert a file in FASTA format to a text file in TABLE
(delimited by tab) format for MS Access.
EXAMPLE:
from FASTA format:
| Quote: | 12345 a description
ATATATATATATATATATAT |
ATATATATTATATATATATT
to TABLE format:
12345 ATATATATATATATATATATATATATATTATATATATATT
PROBLEM:
Sometimes the sequence of A's and T's is so long that even in notepad, it
will wordwrap, despite having wordwrap set off. WordPad does a better job
than notepad, and will accept a little more characters per line, but still
in some cases the sequence is too long that it reaches the line maximum and
begins to word wrap. The problem of wrapping is that it becomes difficult to
import the text file into MS Access reliably.
QUESTIONS:
Is there another format I could use that will allow extremely long lines?
I plan to import the sequence as a memo field, which I heard can take many
characters.
I guess another solution is to use JDBC to connect directly to the database
and import it directly to a table, thereby avoiding the need to save it as a
textfile (doesn't work anyway) before I import.
Any advice appreciated.
Cheers
Sharp
|
|
| Back to top |
|
 |
John C. Bollinger
Guest
|
| Posted: Mon May 23, 2005 4:03 pm Post subject: Re: Java and MS Access |
|
|
Sharp wrote:
| Quote: | Hi
I'm trying to convert a file in FASTA format to a text file in TABLE
(delimited by tab) format for MS Access.
EXAMPLE:
from FASTA format:
12345 a description
ATATATATATATATATATAT
ATATATATTATATATATATT
to TABLE format:
12345 ATATATATATATATATATATATATATATTATATATATATT
PROBLEM:
Sometimes the sequence of A's and T's is so long that even in notepad, it
will wordwrap, despite having wordwrap set off. WordPad does a better job
than notepad, and will accept a little more characters per line, but still
in some cases the sequence is too long that it reaches the line maximum and
begins to word wrap. The problem of wrapping is that it becomes difficult to
import the text file into MS Access reliably.
|
Why do you have to involve a text editor? And what does any of that
have to do with Java? If you create the file in the correct
tab-delimited format in the first place, then can you not import it
directly into Access?
| Quote: | QUESTIONS:
Is there another format I could use that will allow extremely long lines?
|
You are not dealing with a limitation of the file format, you are
dealing with limitations of your viewers (Notepad / Wordpad).
| Quote: | I plan to import the sequence as a memo field, which I heard can take many
characters.
|
You would be well advised to compare the *specifications* for this field
type to the maximum field width you want to support.
| Quote: | I guess another solution is to use JDBC to connect directly to the database
and import it directly to a table, thereby avoiding the need to save it as a
textfile (doesn't work anyway) before I import.
|
You have not yet convinced me that the textfile solution doesn't work,
but if you do want to go with JDBC access to the DB, then you can do.
In that case you need to set up an ODBC data source corresponding to an
existing Access DB, then connect to it via the JDBC:ODBC bridge driver.
--
John Bollinger
[email]jobollin (AT) indiana (DOT) edu[/email]
|
|
| Back to top |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
