.doc/.txt to .mdb?

damnyanks

I'm using Access97 anyone know if its possible to import files from a .txt or .doc into the database file?

Jaden

Erm,

File,
Get External Data.

Change "types of file to" .txt.

Unless you're talking about putting .txt data into an existing database.

---

Hail To The King, Baby.

Jaden.
Mail: jaden@eircom.net

damnyanks

Yeah it's a database I'm trying to put it into, would I be better off creating a new one and linking the tables or is any other way?

[This message has been edited by damnyanks (edited 29-05-2001).]

Bard

<font face="Verdana, Arial" size="2">Originally posted by damnyanks:
Yeah it's a database I'm trying to put it into, would I be better off creating a new one and linking the tables or is any other way?
</font>

probably.

damnyanks

Get a error again, its really annoying. Does anyone know if its possible with a batch file and if they do any tips on how to make them I havent a clue

Hobbes

It would probably help if you told people how you want to import it?

Does the document contain data that should be records? Or do you want to create a document control system?

Magwitch

Accesc 97 has an import wizard in the menu bar options that you can point to a text file (or other souce). Access will then insert what it sees as field breaks, which you okey or amend. After that it creates an mdb filled with the imported info.

It can also be used to import data into existing tables as far as I know. - Hope that is helpful

---

Keep your powder dry and your pants moist

damnyanks

I want to put each record into its own field. I already tryed to import the info and link tables its no good thing crashes