I would like to import a table using VBA (thus making it automatic on opening main form). I have tried the code layout bellow
'TransferDatabase(TransferType, DatabaseType, DatabaseName, ObjectType, Source, Destination, StructureOnly, StoreLogin)
but have had no success ! to import the table manually these are the steps i follow :
1) File - Get External Data - Import
An import box opens then
2) i use the drop down box 'files of type' to find odbc
This then opens a box called 'select data source'
3) i select the 'Machine data source' tab
This gives me a list
4) i select SageLine50v10
I am then asked for a user name and password
5) Once i have entered the user name/ password I am given the import objects box
6) i now click on the table and press ok
THE TABLE IS NOW IMPORTED : -)
Is it possible to automate this process ???
any help would be fantastic !!!!1