Topics Search

Saved Imports

Saved Imports
Views: 22
I am developing a project in which I want to import data from another datasource on a regular schedule.

I went through External Data, imported the tables from the datasource and saved the steps.
When I re run Saved Import it imports the tables but only as a copy, so tblContacts is imported as tblContacts_1.

Do I need to create vba to delete the tables before the importing is done?
Is there a way to tell the Saved Imports to overwrite the existing tables
Sponsored Links:

More topics

 

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
 

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.
 

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
 

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.
 

Access 2010 Saved Imports

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

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.
 

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?
 

Run saved import spec in VBA

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

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