ACCESS - Macro using TransferSpreadsheet

[fz1syc]

I have a form with a text box. In the text box I want customers to key a file name which includes the entire path. Using a command button, a macro will execute a TransferSpreadsheet. How do I tell the macro what data to pick up from the form?

Thanks for your help!

 

[bat17]

You will need to do this in code rather than a macro.

from help, the format is :-
DoCmd.TransferSpreadsheet [transfertype][, spreadsheettype], tablename, filename[, hasfieldnames][, range]

Giving this as an Example :-
DoCmd.TransferSpreadsheet acImport, 3, "Employees", "C:\Lotus\Newemps.wk3", True, "A1:G12"

To make this work using the file name from a field called txtPath you would use :-

DoCmd.TransferSpreadsheet acImport, 3, "Employees", Me![txtPath], True, "A1:G12"


HTH

Peter

 

[fz1syc]

Thank you for your help!!!!!