Import Specs - Multiple Users

[xljunkie]

From what I've read import specs get saved in 2 system files. Does this mean this particular import spec is saved locally on your own machine? I want to create a VBA button that will import files the same every time using an import spec, but I want multiple users to be able to use it. If the import spec is saved within the actual database itself then I assume others can use it?

 

[Joe4]

Yes, the Import Spec is saved along with the database. So anyone who uses the same database should have access to the Import Spec (barring any funky security settings where different people purposely have access to different things - not even sure if that is possible with Import Specs).

 

[xljunkie]

Thanks!

 

[xljunkie]

DoCmd.TransferText(acImportDelim,"Uref Import Specification", "tblEquipmentList", EquipTextFile)

What's wrong with my VBA line? I get a compile error expected:=

EquipTextFile is a string of the full file path of the text file I want to import.

 

[xljunkie]

Strangely enough I took off the parentheses and I don't get the error anymore.

 

[Joe4]

When using DoCmd, I don't think you typically use parentheses with TransferText.
See the VBA example in this detailed description: https://msdn.microsoft.com/en-us/library/office/ff835958.aspx