Topics Search

Access 2010 Saved Imports

Access 2010 Saved Imports
Views: 101
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:

More topics

 

Saved Imports

Preview
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

Preview
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

Preview
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

Preview
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

Preview
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

Preview
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

Preview
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?

Preview
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

Preview
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

Preview
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).