Import Objects with VBA
Thank you for taking the time to report an issue.
What's wrong... Please write below.
Want to run an import spec that imports and appends data from Excel to my Access table. I ran the import process, saved the import spec, naming it "Import-PGI_Data" then, in my VBA for my button:
I keep getting "argument not optional" error.
Currently, I have 3 tables that I update monthly manually by means of the Import Wizard, but I am looking to automate the process as much as possible.
At the least, I would like to hit a button in a form that imports a particular Excel file (the name doesn't change from month to month) and at least brings me into the import wizard.
I am just starting out in VBA,
So far I found Application.CurrentProject.ImportExportSpecificati ons.Item but that is read-only and asking for the name of my stored import
How can I stop a user from simply creating a new database and importing the objects from mine? Although they can't import the tables themselves, they can import the links and see all the data contained in them, and they can import the forms etc.
How can I stop a user from simply creating a new database and importing the objects from mine? Although they can't import the tables themselves, they can import the links and see all thedata contained in them, and they can import the forms etc.
When I import the objects into a new db the problems get solved except I do not have the ULS of the old database.
Can I import the database objects with current security settings?
I want vba to be able to look at the first 3 letters of the file name to identify it. Then take the next 3 and import all the data to a table.
i.e. file name
I want it to look at  which is a code linked to a table
import all the data to a table and add [APT] to the table as an identifyer
Importing data through VBA code enables you to work with a variety of formats that is not available when you do it using the visual interface such as delimited text in a text file or data in a word table.
On a more practical level, if you need to make the same import every time, then simply creating a function to do the job for you will make the process faster and easier as opposed to going through the import wizard every time.
where BasicFile the name is of the file where to import
GetImportFile() the name is of the file to import
then I receive at some places in the table strange characters :for exemple : Pav d'Ath / Rue Flix Bovie / Rosires
It seems that there is a problem with the special french characters : ,
Could it be a prbl with the codepage? and so how can I resolve it and include in this VBA sentence