473,385 Members | 1,838 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

Import Specifications

I have an Access macro that imports and exports a number of text files using import and export specifications. It was working fine until I edited it to add new imports. I select the import specification from the list after creating it with a manual import, and the name appears in the macro. But when I run the macro, the name is converted to a number, and it can't find an import specification of that number, so it aborts.

The database was in Access 2000 format, and I have upgraded to Office 2010, but with the 2010 program, it is behaving the same way with the database in either 2000 or 2007-2010 format.

I have been ripping my hair out over this for many hours. I have tried recreating the macro from scratch, deleting and re-creating the import specifications, and the result is always the same. My only solution appears to be to convert the macro to Visual Basic and replace the numbers with the specification names there. But you are supposed to be able to edit a working macro without the whole thing blowing up.

It looks like Calvin Dent reported similar behavior in this forum on 4/6/11 with a specification being turned into a number. Did Microsoft screw up macro editing in the 2010 version?
Oct 26 '11 #1
2 3357
I went around my first issue by converting the macro to Visual Basic and editing the specification name in the code, but then I ran into another problem with specifications that has me 100% stumped. On the 5th file I am exporting, it says that the 1st field name in the export specification does not exist in the table, even though it is correct and is identical to the 1st field name in the previous 4 files. A manual export works fine. I have re-saved the export specification at least 6 times. Repairing Office and the database file changed nothing. The error message puts an underscore instead of a space in the field name. I don't know if that is significant or not. I tried putting an underscore in the table and export specification, but it does not help. Any ideas?
Oct 27 '11 #2
Never mind about the second issue--it was a dumb error: the command was trying to import instead of export. The issue that remains is--is there away to use import and export specifications in a macro without going to Visual Basic?
Oct 27 '11 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: mark | last post by:
In Access 2000 and 2002, I have created an import specification to import the fixed-width recordset below into an existing table. I am having strange problems with the import of the date and time...
3
by: dixie | last post by:
Can I alter or delete an import specification without actually doing an import of data into the database. Can it be done in code? dixie
1
by: PeteCresswell | last post by:
I'm just starting in 2003, hoping to find a more direct route to editing/listing Import Specifications than in 2000 - where you have to initiatate an import, choose "Advanced", and then load a...
4
by: pietlinden | last post by:
I almost feel stupid posting this, but maybe someone else understands what's going on here. I am importing a delimited text file, and have saved an import specification so that for the user the...
3
by: holdemfoldem | last post by:
Hi. I'm new to this board and have a few questions about using the method referred to in the topic of this message. I have manually transferred over 1/2 million records from a text file into my...
4
by: BostonNole | last post by:
I am looking for suggestions on the most efficient way to import 7 different fixed width files into a DataSet. Not all at the same time. One file at a time, but the format could change from file...
10
by: Avi | last post by:
Hi I need to read in a large set of text files (9GB+ each) into a database table based on fixed width lengths. There are several ways to complete this, but I am wondering if anyone has...
1
by: lorirobn | last post by:
Hi, I have been manually importing a text file on a weekly basis to an Access table. The data on one field is about to change (happens to be the first field). It was numeric, and is defined as...
2
by: pendell | last post by:
I am working with a client running 2003 Access. Some time ago I built them an import spec for use with the Import Wizard. Several months later, I have been called back and asked to solve a...
4
by: Calvin Dent | last post by:
Hey Guys, I'm trying to set up a Macro to Transfer Text into a created table. Because the table has no headers I'm using an Import Specification to do it. Unfortunately, The Macro dropdown...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.