answersLogoWhite

0


Best Answer

There are two methods to add a text file to a MS access Database.
1) Link the text file. Go to File/Get External Data/ Link Tables. In the link file screen change the file type to Text file and then browse to the text file and select your text file. MS Access will prompt you to give the specs of the file when you are linking it. 2) Import the file to an access table. Go To File/Get external Data/ Import. In the screen change the file type at the bottom to text, and select your text file.

User Avatar

Wiki User

17y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: How do you add text files to a MS Access database?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

How do you access css Im not sure if its in HTML im not sure how to access either of these?

You need to have the files in the same folder. Add this to HTML: <link rel="stylesheet" type="text/css" href=".css">


How do you add PDF files to a website?

If you have access to your FTP, you upload the PDF into the website files.


How do you create a file using terminal in Linux?

You can use cat to create files by specifying an input for it and redirecting its output to a new file.cat file1 > file2That would make a copy of file1 and call it file2. To join two or more files, you can simply add more files for cat to read. cat file1 file2 file3 file4 > file5


You want to add a predefined text watermark to the document you are currently working on Which steps would you use to do this?

*Access the Page Layout groups and commands *Choose a predefined text watermark *Access the Watermark gallery


What are the differences between Access and Oracle?

The difference between Access and Oracle is Access has minimum security features and you can create a small to medium sized database. Oracle has NY security, which allows you to determine who can or can not get access to your data. Access you can't add too many users without it getting slow, and Oracle allows you to add thousands if you want to.


How do you make gif stories on Tumblr?

1. Add a text post. 2. Right above the big box to type is an "add photo" button. From there, add gifs that you have saved as files on your computer. You can add as many as you want, but they must be within size limit, or they will only appear at little gray boxes. You are able to add text around images on this post.


You want to add a predefined text watermark to the document you are currently working on?

Acces the Page Layout groups and commands Choose a predefined text watermark access the watermark gallery


How do you save javascript?

You can save JavaScript files with any text editor of your liking. Just add the .js file extension and you're good to go.


How do you add text style files in GstarCAD?

Copy font files to corresponding catalog GstarCAD Professional\Fonts. Please don't copy the whole font file of other software to GstarCAD randomly; it is better only to copy useful font files.


What is append command in dbase?

The APPEND command in dBase is used to add a new record to a database table. It is similar to the SQL INSERT command and allows you to specify values for each field in the new record. The APPEND command is commonly used in dBase programming to insert data into a database table.


How do you add a wired computer to a wireless network and be able to acces files over the network?

Connect a wireless network adaptor to the computer and configure the adaptor to connect to the wireless network that has the files you want to access.


What happens when you add effects on text?

You can't add effects on text, but you can animate the text.