Does any one known how to automate importing data to a table by using a button on a form?
W wayne Apr 18, 2005 #1 Does any one known how to automate importing data to a table by using a button on a form?
K Klatuu Apr 18, 2005 #2 What is the source of the data you wish to import. You will use different techniques depending on whether it is another table, a table in a different Access DB, a text file, a spreadsheet, etc.
What is the source of the data you wish to import. You will use different techniques depending on whether it is another table, a table in a different Access DB, a text file, a spreadsheet, etc.
J John Vinson Apr 19, 2005 #3 Does any one known how to automate importing data to a table by using a button on a form? Click to expand... Yes. See the Help in the VBA editor for the TransferText, TransferSpreadsheet, or TransferDatabase methods as appropriate. John W. Vinson[MVP]
Does any one known how to automate importing data to a table by using a button on a form? Click to expand... Yes. See the Help in the VBA editor for the TransferText, TransferSpreadsheet, or TransferDatabase methods as appropriate. John W. Vinson[MVP]
