Re: Import fields
- From: "Allen Browne" <AllenBrowne@xxxxxxxxxxxxxx>
- Date: Mon, 10 Apr 2006 09:13:35 +0800
You can use an Append query statement to import specified fields into your
table.
Example:
strSql = "INSERT INTO MyTable ( CusID, Company ) " & _
"SELECT Customers.CustomerID, Customers.CompanyName " & _
"FROM Customers IN 'C:\northwind.mdb';"
dbEngine(0)(0).Execute strSql, dbFailOnError
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Jay" <libertysmith@xxxxxxxxxx> wrote in message
news:Xag_f.502$_c1.471@xxxxxxxxxxxxx
Is there an event procedure that will import a table from an access
database
to another access database and only 4 fields instead of all 10 fields.
I would like to be able to select fields I need. I can do it with
a text file.
.
- Follow-Ups:
- Re: Import fields
- From: Jay
- Re: Import fields
- References:
- Import fields
- From: Jay
- Import fields
- Prev by Date: Re: campaign financial disclosure template?
- Next by Date: Re: Populating Databse
- Previous by thread: Import fields
- Next by thread: Re: Import fields
- Index(es):
Relevant Pages
|
