Go Back   TechArena Community > Software > Windows Software
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Thread Tools Search this Thread
Old 23-06-2009
Join Date: Mar 2009
Posts: 56
import text file into ms access

I am using MS Access & one of my client had sent me a file of a project in the word format. I was wondering that is it possible to import the word file into my Access database. My colleague told me that it it possible to do, but don't know the way how to do it.... Does anyone know How to Import text file to MS Access????
Reply With Quote
Old 23-06-2009
Join Date: Apr 2008
Posts: 4,641
Re: import text file into ms access

Here is the direct solution from Microsoft just follow the link given below :

How to Import Text File into Microsoft Access Table Using DDE
Reply With Quote
Old 23-06-2009
Join Date: May 2008
Posts: 4,339
Re: import text file into ms access

How to import text file to MS Access :
  1. Follow these steps when your Microsoft Word document contains tables, and you want to import those tables into Microsoft Access. In Word, save a copy of the file as a comma- or tab-delimited (delimited text file: A file containing data where individual field values are separated by a character, such as a comma or a tab.) unformatted text file.

    1. If the data is already saved in comma-delimited or tab-delimited format, skip ahead to step 3.

    2. If the data is in a table, convert the table to text.

      1. Select the rows or table (table: One or more rows of cells commonly used to display numbers and other items for quick reference and analysis. Items in a table are organized into rows and columns.) that you want to convert to paragraphs.

      2. On the Table menu, point to Convert, and then click Table to Text.

      3. Under Separate text with, click Commas or Tabs.

    3. Make sure the delimited text file has the same type of data in each field and the same fields in every row.

    4. On the File menu, click Save As.

    5. In the File name box, enter a new file name.

    6. In the Save as type list, click Plain Text, and then click Save.

      • Note : If you are prompted that formatting will be lost, click OK.

  2. Switch to Microsoft Access, and then open a new or existing database.

  3. In the Database window, click Tables on the Objects bar.

  4. On the File menu, point to Get External Data, and then click Import.

  5. In the Files of type box, click Text Files.

  6. Click the text file that you want to import, and then click Import.

  7. Follow the directions in the Import Text Wizard dialog boxes.

To see more options or to change specifications, such as the field separator character (separator characters: Characters you choose to indicate where you want text to separate when you convert a table to text, or where you want new rows or columns to begin when you convert text to a table.), click Advanced in the first wizard dialog box. Doing so starts the Import Specification dialog box. To save your new specification for later use, click Save As.
Reply With Quote

  TechArena Community > Software > Windows Software
Tags: , , , , ,

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Similar Threads for: "import text file into ms access"
Thread Thread Starter Forum Replies Last Post
Need help to import a Microsoft Excel file to semicolon delimited text file Roch Windows Software 5 13-01-2012 05:18 PM
How to eliminate and import text variables in InDesign CS5? Feng Windows Software 4 11-08-2010 05:19 PM
Import a text file in JTextPane Ash maker Software Development 5 22-01-2010 11:17 AM
How to import Text into Access through VBA appueye Software Development 2 17-04-2009 11:10 PM
Vba import text files Naval Software Development 1 24-03-2009 11:35 PM

All times are GMT +5.5. The time now is 11:29 PM.