Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Using acCmdImport to import data?

Status
Not open for further replies.
realstandman

realstandman

IS-IT--Management
Oct 29, 2003
87
US
Using Access 2000 I currently have a command button on a form that has the following code
DoCmd.RunCommand acCmdImport
Then I have another command button that renames the imported table to a table I use in various queries.
DoCmd.Rename "TEXN TOP TEN DATA", acTable, Text24
The Text24 is a box for the user to enter the imported table name and the button renames it to TEXN TOP TEN DATA.

What can I do with a command button to import a dbf file to an existing table (TEXN TOP TEN DATA)?

STANDMAN
 
Status
Not open for further replies.

Similar threads

I
  • Locked
  • Question
How to get 2 codes to work together.
Replies
6
Views
757
hermanlaksko
hermanlaksko
TrekBiker
  • Locked
  • Question
Form Data Not Updating
Replies
6
Views
784
dhookom
dhookom
TrekBiker
  • Locked
  • Question
Sending data to Excel 1
Replies
2
Views
330
TrekBiker
TrekBiker
Lamar Washington
  • Locked
  • Question
Programmatically send email using only OWA
Replies
2
Views
475
Andrzejek
Andrzejek
PrimoSteve
  • Locked
  • Question
Cannot add Image to Command Button?
Replies
9
Views
1K
PrimoSteve
PrimoSteve

Part and Inventory Search

Sponsor

Back
Top