Will someone please verify for me that these three methods, TransferText,
ExportXML and ImportXML, can only be run on the current database, i.e. I
can't run these from the front end in order to create either text or xml
files for tables in a backend.
Thank you.
--
Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...ccess/200608/1 3 1887
"rdemyan via AccessMonster.com" <u6836@uwewrote in news:64aa3e16ab941
@uwe:
Will someone please verify for me that these three methods, TransferText,
ExportXML and ImportXML, can only be run on the current database, i.e. I
can't run these from the front end in order to create either text or xml
files for tables in a backend.
Sure! TTBOMK, RDemyan can't run TransferText, ExportXML and ImportXML from
the front end in order to create either text or xml files for tables in a
backend (IIRCC).
HTH
--
Lyle Fairfield
Alright then. I guess I'll put the code in the backend and then use
automation to run it from the front end.
Lyle Fairfield wrote:
>"rdemyan via AccessMonster.com" <u6836@uwewrote in news:64aa3e16ab941 @uwe:
>Will someone please verify for me that these three methods, TransferText, ExportXML and ImportXML, can only be run on the current database, i.e. I can't run these from the front end in order to create either text or xml files for tables in a backend.
Sure! TTBOMK, RDemyan can't run TransferText, ExportXML and ImportXML from the front end in order to create either text or xml files for tables in a backend (IIRCC).
HTH
--
Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...ccess/200608/1
"rdemyan via AccessMonster.com" <u6836@uwewrote in
news:64ad579145fb8@uwe:
Alright then. I guess I'll put the code in the backend and then use
automation to run it from the front end.
Lyle Fairfield wrote:
>>"rdemyan via AccessMonster.com" <u6836@uwewrote in news:64aa3e16ab941 @uwe:
>>Will someone please verify for me that these three methods, TransferText, ExportXML and ImportXML, can only be run on the current database, i.e. I can't run these from the front end in order to create either text or xml files for tables in a backend.
Sure! TTBOMK, RDemyan can't run TransferText, ExportXML and ImportXML from the front end in order to create either text or xml files for tables in a backend (IIRCC).
HTH
Great! Let us know how it goes, and it would be kind of you to post your
code. Except for creating tables in the backend, I always do all this from
the front end so it will be interesting to compare our methods.
--
Lyle Fairfield This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: BigData |
last post by:
I am attempting to create a delimited text file by using
DoCmd.Transfertext as shown here.
DoCmd.TransferText acExportDelim, "ExportSpec", "QryFinalExport",
"Fileout.txt"
This works fine as...
|
by: Trev |
last post by:
A2K2
If I use:
Application.ImportXML "MyFile.XML", acStructureAndData
I get a table in my database, not ncessarily called "MyFile". So without
building an array of tables then comparing...
|
by: Patrick A |
last post by:
All -
2 questions, the answer to either one having the possibility of making
the other a moot point:
1. I have a DB with a form that serves as a GUI to let the user browse
for an XML file and...
|
by: Richard Sherratt |
last post by:
I have to generate some XML files with some header-type tags that I
can't work out how to generate using Application.ExportXML.
e.g., ExportXML gives me the following at sthe start of the file:
...
|
by: nepifanio |
last post by:
Hi Guys,
I'm trying to import data out of MySQL db to MS Access 2003 using
ImportXML. I don't have any problems doing the import, except for one
table with a "text" field defined. I'm getting...
|
by: BenWeber |
last post by:
I have XML formed as follows (this is just a part of the XML)
- <players>
- <player id="814090">
<name>Brian</name>
<surname>Bradford</surname>
<countryfrom id="4">USA</countryfrom>...
|
by: Jim M |
last post by:
I am trying to 'grab' a backend data path and filename from a text file
(to be used when updated front ends are installed by users). I store
this information by running:
DoCmd.TransferText...
|
by: bernard.thouin |
last post by:
Hi
I have an Access 2000 app where I will soon get an XML file as an input
(of which I already have an early test file), instead of an Excel
spreadsheet. So I set out to see how to import the...
|
by: heinzW |
last post by:
Hallo,
ich schreibe ein VB-Programm, das eine MDB-Datei verwendet. Weiß jemand, ob für die beiden Funktionen ExportXML und ImportXML Access installiert sein muss, da dies bei unserem Kunden nicht...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
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...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
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...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
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,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
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: 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...
| | |