Access 2010 Saved Imports

Is there a way to use a command button to execute a Saved Import? I have a Saved Import that I execute using Access default options. A command button on the switch board would be nice. Any information or direction would be much apprecated!

On a related note - I have a Table called "2011" that gets updated via the Saved Import process. This process brings over a Table called 20111 which I have to rename 2011, by first deleting the already named 2011. Is there a code that can do this that can be run through a command button?

Sponsored Links:

Related Topics

Saved Imports
I am using Access 2010 and have some saved imports which work well but I need to call them from a command button or in a macro and then proceed to other functions. My problem is that currently I can get to the Save Imports Dialog box but then have to click 'Run' then afterwards close the dialog box before the remainder of the routines run.


Problem with Access Import Text Wizard; Saved Imports
I am encountering a curious scenario today. I am running the Access Import Text Wizard; I define several DataTypes as Double and several as Text. When I run the Wizard, I save the Import and everything imports just fine.

If I later click External Data > Saved Imports, and then run the Saved Import, I have to wait for a while, just like the initial import (it’s a large file).

I then get a message that says all objects were imported correctly. However, NOTHING is imported. The entire table is completely blank. Has anyone encountered thisbefore?

I am using MS Access 2010.


VBA to Import Excel Worksheet
Have been using the saved imports in access to import excel data into access tables. Like the way it works except for the difficulty when you have to move the program from one directory to another, means have to redo all of the saved imports to reference the new location. Very time consuming.

Is there VBA code that will perform the same action as the access saved imports? That way, just have to change the location in the code instead of redoing the saved import


RunSavedImportExport
I'm trying to create a macro that imports Excel data into a table so that I can create a switchboard button.

I created my import successfully and saved the steps. It works fine and the import shows in the Saved Imports list (External Data > Saved Imports)

When I create the macro, I am trying to use the RunSavedImportExport action, but the import does not appear in the dropdown list of Import Export Names available to use. In fact, there is nothing in the dropdown list. I've tried closing the database and re-opening. nothing.

If it makes a difference, this is a split database.

Any idea why the saved import wouldn't be in the list


Importing CSV file into 2010/creating save import routine
I'm not sure whether this should be 2 separate posts, but since it's a similar problem -
I created a program in 2003. It has a saved import routine that imports a CSV file from C:\program files\exports\data.csv. No problems.

In 2010, that function stopped working as Access said that the import routine 1 didn't exist. I recreated it in 2010.

First of 2 problems -
The import routine doesn't import the data as entered, which makes it very difficult to proof.

Second of 2 problems -
I thought that deleting the saved import specs and re-creating them with a different name might solve the problem. No go. When I go to the import step in the macro and try to select the newly named/saved routine, it doesn't appear in the list. No matter what I've done (even compact/repair), no luck.


Importing CSV file into 2010/creating save import routine
I'm not sure whether this should be 2 separate posts, but since it's a similar problem -
I created a program in 2003. It has a saved import routine that imports a CSV file from C:\program files\exports\data.csv. No problems.

In 2010, that function stopped working as Access said that the import routine 1 didn't exist. I recreated it in 2010.

First of 2 problems -
The import routine doesn't import the data as entered, which makes it very difficult to proof.

Second of 2 problems -
I thought that deleting the saved import specs and re-creating them with a different name might solve the problem. No go. When I go to the import step in the macro and try to select the newly named/saved routine, it doesn't appear in the list. No matter what I've done (even compact/repair), no luck.

I'm stumped at this point and could sure use the


Saved Import Export Executes but Creates new local table
I am trying to use a saved import routine in an Access 2010 database (in a VBA Sub: DoCmd.RunSavedImportExport "Import-X"); the routine was created by a user who is no longer available.

My research on this subject indicates that one can neither view details nor edit these saved imports - oh, well. I understand that the only path is to recreate,

Here's the issue: when designing the steps, I specify a table where to import the data - the table specified is a linked table to a backend Access database. I'm trying to do this in thefront-end database - the one with the links to the back end tables.

The import executes fine - the only problem is that once complete, it has created a new local table of the same name in the front end (and obviously overwrites the reference to the linked back-end table).

this behavior is unacceptable - not to mention frustrating.

Am I missing something? Or is this a "feature" of Access 2010.


ADP-files - how queries etc. are imported?
I was shown at work an adp-file, which is in 2002-2003 format, I'm using this with Access 2010. The size of the file is about 81 kilobytes, but it has tens of thousands of records inside. It dynamically receives queries from SQL Server (or at least my supervisor said that he never creates new queries into Access, still it gets them as they are in SQL server) and I can't see forexample VBA code inside the adp-file.

I'm supposed to fix this program, but to begin with, I would need to find where exactly the logic is that imports the queries etc. Saved imports has nothing. VBA Project has nothing. There's no macros.

So shortly: Where is the logic in adp-files?


programmatic file imports and file dialogs
I have a regular process wherein I import two excel files into Access as tables, and run a series of queries on them. I am trying to automate this process as much as possible. The data in the files in different every time, but otherwise the process is the same.

Part I: I want the user to get a file dialog from a form, so that they can search the hard drive and locate the files to import. Then, I imagine, the paths of the two files selected would be stored in text boxes.

Part II: The user would click a 'go' button, and both files would import. The imports happen according to pre-defined parameters, I.e. only some of the fields would be imported (the same ones every time).

Part I: And then the queries run, which I think I can do myself.

Surely this scenario is very common, yet I can't find a clear set of instructions for doing it online. the file dialog in particular seems to be complicated and depend on one's version of Access (mine is Access 2007).

what I want to do is a saved import. which is an existing Access feature. The problem is that with the saved import feature, you must always import the same file, from the same place, every time.


Access 2003 with Windows 7, create replica, program stops working
We still heavily use the Access replication function and have successfully done so for years with WIndows XP+Office 2007+Access 2003 on each machine.

I am testing a new combination of programs including: Windows 7, Office 2010 (not 2010 access) and Access 2003. We do not have the HP protect tools installed.

I have gotten most of our functions to work, including some pretty extensive VBA imports & exports to/from Excel 2010 (better than expected).


Exclusive access 2003/2010 environment
We run on a network with some having Access 2010 and some using Access 2003. The application in question was created using 2003. When 2010 users attempt to open it (unless thjey are the first of the day) an error message appears indicating they do not have exclusive access and that changes may not be saved. After hitting enter about 10 times, the application finally opens and there are no further issues. How do I get rid of the annoying error message for the 2010 users?


Importing CSV file
I am importing the CSV file into MS Access 2000 and it imports into a new table without any extra blank records. But if I import the same file into MS Access 2010 I get an extra blank record.

Do you know why this would happen in MS Access 2010, bit puzzled. Also a way to overcome this


Compatibility of mdb Format Over Ms Access 2010, Office 2010
While adding any simple command button (having code)on Microsoft form created in MS Access 2003(mdb) and try to save it in MS Access 2010 in same db format (mdb), I am getting the following error

"This form or report contains changes that are incompatible with the current database format. The form or report was not saved."

This way I am not able to add any control on mdb format using MS Access 2010. Could anyone help me out how it can be possible


Run saved import spec in VBA
Thought this would be easy, but getting error message

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:

DoCmd.RunSavedImportExport "Import-PGI_Data"

I keep getting "argument not optional" error.


Can't create 2007 format accdb!
This is doing my crust in!

I've found loads of web sites that tell me how to create an accdb file from within VB.Net 2010.
I've written this function which creates the file and I can open it in Access 2010.

*HOWEVER*
When I open it, the first thing Access does is "repair" it, then it opens it as 2002/2003 format!

What on earth is going on?

I have a reference to MS ADO Ext 6.0 for DDL and security.

Imports ADODB Imports System.IO Imports Microsoft.VisualBasic Module modADO
Public Function CreateDB(ByVal sDBpath As String) As Boolean
Dim bRET As Boolean = True
'Add a reference to ADOX (Microsoft ADO Ext. 6.x for DDL and Security)
Dim ADOXcatalog As New ADOX.Catalog
ADOXcatalog.Create("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & sDBpath & "myAccess2007file.accdb;Jet OLEDB:Engine Type=5;")
Catch ex As Exception
Debug.Print(ex.ToString)
bRET = False
End Try
ADOXcatalog = Nothing
Return bRET
End Function End Module


accdb 2007-2010 problems!
I created an accdb using Access 2010, it opens in both Access 2007 and 2010.

The problem is that any changes made using one version are not shown in the other version.

I spent all day yesterday changing and adding things, I saved all changes, opened the file in A2007 and everything was fine, I then opened the file in A2010 and now none of the changes arethere (even when opened in A2007).

On a side note: In A2010 I couldn't save the file as a mdb, I got the message about having functionality that isn't supported in mdb (which isn't true, and as proof I created an empty 2007accdb, imported all objects from the A2010 accdb, and then successfully saved as mdb).


Access 2010 - Creating a Data Macro
Office 2010 Developer Training Course > Access 2010 > Building Solutions with Access 2010 Lab using the Contacts Web Database template.

I'm at Exercise 4: Creating a Data Macro and for whatever reason my macro is not working at all.

I created the macro and confirmed it matched to the guide and I had no errors when I saved it, so that has to count for something.

The macro is suppose to be invoked when the 'Status' variable is "Offer Outstanding" more than once in the database.

Yet I can select it multiple times without any instances of the macro displaying any warning message as it should.


Macro command RunSavedImportExport
So after discovering how to "enable" the often referenced but well-hidden RunSavedImportExport macro command (tell Access to list all commands, not just ones for "untrusted databases"), I am now wailing and gnashing my teeth trying to figure out why I can't enter the name of a saved Import into the argument field.

If I look under the Save Imports option on the External Data tab, I SEE IT RIGHT THERE!

There are no spaces in the name or anything. But when I type it into the argument column or the Saved Import Export Name text box at the bottom, it won't acceptit.

Microsoft's documentation on this is of no use whatsoever (unless it's one of those subjects where you have to already know the answer in order to ask the question.)

It's a macro, for crying out loud! If I wanted this much secrecy,


Import & Link HTML Datasheet In Access 2010
Access 2010 lets user import web datasheet which could be very useful, especially when you are dealing with data tables saved in HTML format. Through importing them to Access 2010 database you can easily start defining data types and apply constraints. Apart from importing data table, you can also link web datasheet with Access 2010 database table which enables smooth synchronization between data tables.


2007 Access file cannot be opened in 2010 Access
I have this Access file that was created in Access 2003 version. I saved a backup copy on a thumb drive and I cannot get it to open in my 2010 version of Access. It opens in 2007, 2003 versions, but won't open on my laptop, which is a 2010 version.

The error message reads: Your MS Access database or project contains a missing or broken reference to the file 'MSCAL.OCX' version 7.0

To ensure that your database or project works properly, you must fix this reference.

Again, it openes on other computers, just not this one. So, there is no problem with the file itself. It is a problem with this laptop, or this MS Access 2010.