MySQL Forums
Forum List  »  Microsoft Access

Re: Import Access Tables
Posted by: David Lee
Date: January 04, 2010 07:56AM

Pasting From Another Application

Step 1
Open your database file in Microsoft Access.

Step 2
Use the F11 key to open the Database window.

Step 3
Click on the Table tab. A listing of your tables appears.

Step 4
Select the table you want to work with and click Open.

Step 5
Open the application that contains the data you want to bring in. Be sure the data is in a format that Access can use. If the information is in a word processor, it must be formatted in a table or else each "field" must be separated by tabs.

Step 6
Ensure that the order of the columns in the data to be pasted matches the order of fields in your database table.

Step 7
Select the rows you want to copy, then select Copy from the Edit menu.

Step 8
Going back to Access, decide whether you want to replace old records with the new ones, or whether you want to add the new records at the end of the data sheet.

Step 9
To replace, select the records to be replaced, then click Paste from the Edit menu. The records replace the ones you selected.

Step 10
To paste the records at the end of the data sheet, go to the Edit menu and click Paste Append. The records will appear at the bottom of the sheet.

Importing From a Spreadsheet or Text File

Step 1
Realize that data can be imported directly into a table only if the external application is a spreadsheet or text file.

Step 2
Open the Database window.

Step 3
From the File menu, select Get External Data, then Import.

Step 4
Move through your folders until you locate the file containing the data you want to import.

Step 5
Select the file, then click Import.

Step 6
An Import wizard appears. Use the wizard to import your data. When asked, select the table that you want to receive the new data.

http://www.cheapflightstocapetown.org

Options: ReplyQuote


Subject
Views
Written By
Posted
16006
December 18, 2009 01:42PM
9603
December 18, 2009 03:58PM
6157
December 21, 2009 02:10AM
4526
December 21, 2009 02:16AM
3822
December 21, 2009 08:46AM
3795
December 21, 2009 09:51AM
Re: Import Access Tables
4856
January 04, 2010 07:56AM
3633
January 20, 2010 02:16PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.