Is there a way to create/manipulate import specs in VBA? 3 8773
On Wed, 29 Sep 2004 13:40:29 +0100, "Trev@Work" <no.email@pleas e>
wrote: Is there a way to create/manipulate import specs in VBA?
Hi
Don't know if anyone has done this. According to KB article 119472
which applied to Access 97
"Import/export specifications are stored in the system tables
MsysIMEXSpecs and MsysIMEXColumns . "
It might be easier to write the whole import routine in VBA, specific
to your requirement, I have done that in the past
David Schofield
David Schofield wrote: On Wed, 29 Sep 2004 13:40:29 +0100, "Trev@Work" <no.email@pleas e> wrote:
Is there a way to create/manipulate import specs in VBA?
Hi Don't know if anyone has done this. According to KB article 119472 which applied to Access 97
"Import/export specifications are stored in the system tables MsysIMEXSpecs and MsysIMEXColumns . "
They're still there in 2002 but there's dangers for working directly
with system tables in any application being as they're generally
undocumented and for that reason, may change in a future version
rendering any code written on them useless. The added fact that those
two particular tables are read-only to us mortals didn't help either :-)
It might be easier to write the whole import routine in VBA, specific to your requirement, I have done that in the past
I've gone about it now by parsing the file and creating a CSV file from
that then linking directly to it, this doesn't need an import spec to
know where the delimiters are.
--
\\\\\\
\\ \\ Windows is searching
\ \ For your sig.
\ \ Please Wait.
\__\
"Trevor Best" <nospam@localho st> wrote in message
news:41******** *************@a uth.uk.news.eas ynet.net... "Import/export specifications are stored in the system tables MsysIMEXSpecs and MsysIMEXColumns . "
They're still there in 2002 but there's dangers for working directly with system tables in any application being as they're generally undocumented and for that reason, may change in a future version rendering any code written on them useless. The added fact that those two particular tables are read-only to us mortals didn't help either :-)
If you make Select queries on these tables, they can be freely updated by
hand, at least in Access 2000 and 97. Or you can modify values directly
using append and update queries.
- Steve This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: B.Desai |
last post by:
Hello Experts,
Can you please help me out? I am very frustrated!
I am trying to update import specification, and it does not let me do
that. I have saved specification and now I need to add one extra
field at the end of the file (importing txt file). I open the saved
specification than add new name of the field and its specification, go
through the entire process, and at least it reconginse that I have
made changes to the spec, so...
|
by: DCM Fan |
last post by:
Access 2K, SP3 on Windows 2K, SP4
All,
I have an import spec set up with quoted Identifiers and comma-separated
values. The text file is produced by a 3rd-party program of which I have no
control. It outputs all text fields surrounded by quotes, and all numeric
fields w/o quotes. All fields are separated with commas.
This has been working for 2 years, until today, when one of the data fields
|
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 fields.
177 102003 16:43:12 102003 18:43:12 6OAG0ADP Y 0000 0000 0000 0000 61930 4HGA800
165 102003 17:43:12 102003 18:44:12 6OAG0ADP Y 0000 0000 0000 0000 61930 4HGA800
177 102003 16:41:18 102003 18:45:12 6OAG0ADP Y 0000 0000 0000 0000 61930...
|
by: khutch |
last post by:
Not that up on MS Access. I understand that the TransferText command
can be used to import csv files into a database. Question: Does the
text file have to mirror the alignment of the table columns e.g. must
field1, field2, filed3 etc correspond to col1, col2, col3 on the
table? or can I state somewhere which columns in the text file
correspond to which table columns. I actually need col1, col2, col5
and col6 from the text file to populate...
|
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 whole thing is essentially
pushbutton. Except for some reason, it seems my import spec thinks
summer is a good time to pack up and go on vacation, so when the user
tries to run the import, I get error 3265 (missing spec), and the
import...
| |
by: ghadley_00 |
last post by:
Hi,
I have a MS access database table for which I regularly need to import
fixed width text data. At present I have to to cut and paste the text
data from its source to a text file, save the file, import the text
file as fixed width text , and then run
an update query to copy the appropriate info into fields of a different
table.
Is it possible to write a macro to do all these steps? Also, is it
|
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
problem ... they tried to customize the spec and now the Import Wizard
always fails on the last step (when one presses the 'finish' button),
returning the dialogue box message "Invalid Use of Null".
Running some test, I have determined that the...
|
by: Lee |
last post by:
I have a xml file, here is sample part:
<?xml version="1.0" encoding="UTF-8"?>
<ProducsList>
<Product id="1">
<SpecList>
<Spec>
<SpecLabel>Height</SpecLabel>
<SpecValue>10</SpecValue>
<SpecCat>Dimension</SpecCat>
</Spec>
|
by: Lee |
last post by:
I have a xml file, here is sample part:
<?xml version="1.0" encoding="UTF-8"?>
<ProducsList>
<Product id="1">
<SpecList>
<Spec>
<SpecLabel>Height</SpecLabel>
<SpecValue>10</SpecValue>
<SpecCat>Dimension</SpecCat>
</Spec>
|
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
| |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |