database

[Guest]

i want to create a database using information from a notepad document.do i
have to copy/paste each individual piece of info or is there a quick
way???????????????

 

[JS]

Databases can input information in several text formats that use what are
called delimiters:
CSV - Comma Separated Values (each comma creates a new column)
Other - such as a Semicolon between words or group of words (each Semicolon
creates a new column)
You also may specify custom delimiters, however which delimiter you
use/choose must be contained in the text document in such a manner that
importing the data will result in consistent results for each column in the
database.

JS

 

[Ronnie Vernon MVP]

Yes, if the notepad file was created manually, then there is no structure to the data in the file that can be read by the database program. You will need to enter everything into the database program manually the first time.