Import Button

[kowen091010]

Could some please show me what the code would be to create a command to import and append a table?

Name: Form1
Drive Location:J:\BYY Goal 7 - 2011
Excel File Name: Current Customers
Excel File Type: Macro-Enabled Worksheet


Table 1 - tblaggregateddata - need to add to table
Table 2 - Current Customers - need to replace all information in this table with imported data.
Command Button - Command6 & Command8

I have been trying to write the proper code to get these to buttons to automatically import the data. Unfortunately everything I have tried has failed. Above are the names from my Access Database and Computer Drive. Could someone please help me write the proper code or figure out a macro in order to add a Command Button?

Please and Thank you!!!

[dreday]

Sure, inside the VBA for each button place the appropriate format of the code below:

docmd.TransferSpreadsheet(TransferType, SpreadsheetType, TableName, FileName, HasFieldNames, Range, UseOA)

The options are explained here and intellisense will help you through it too:
http://msdn.microsoft.com/en-us/libr...ice.12%29.aspx

Also, for current customers, since you want to replace all the info in the table just run a quick sql command before the transferspreadsheet command:

Docmd.RunSQL "Delete * from [Current Customers]"

That will wipe out all the data already in the table before the fresh data are imported.

Hope this helps