473,216 Members | 1,257 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,216 software developers and data experts.

Exporting result of a query to a db3 format?

Hi All,

I have an access query which retrieves some record. I can export the results
of it as an excel document, using the function TransferText. What I actually
need is to export the query as a db3 table. I've been suggested that once I
export it to an Excel file, the user has to open the document and to save it
as dbase III (.dbf) file
I expect I should be able to do this operation by code, using VBA.

Any suggestions appreciated

Regards,
Nicolae
Nov 13 '05 #1
4 5174
"Nicolae Fieraru" wrote
What I actually need is to export the
query as a db3 table.


Instead of TransferText, you will use TransferDatabase.

Larry Linson
Microsoft Access MVP
Nov 13 '05 #2
rkc

"Nicolae Fieraru" <no****@please.cxm> wrote in message
news:40********@duster.adelaide.on.net...
Hi All,

I have an access query which retrieves some record. I can export the results of it as an excel document, using the function TransferText. What I actually need is to export the query as a db3 table. I've been suggested that once I export it to an Excel file, the user has to open the document and to save it as dbase III (.dbf) file
I expect I should be able to do this operation by code, using VBA.


You can export from a table or saved query to many formats using SQL.
The format for the query is

SELECT * INTO [dBase III;DATABASE=C:\].[customer] FROM [Customers]

dBase III is the export file type.
C:\ is the full path to the folder to be exported to.
customer is the file name minus the .extention
Customers is the name of the table or saved query.



Nov 13 '05 #3
Dear Larry,

Thank you for your reply. I tried to run this command, but I am not sure if
I have all the arguments right.
I want to export the results of the query named "ClientRecordQuery" into the
database "ClientRecordDBF.dbf" in the same folder as the Access application.
If my Access application is called "Access DB.mdb" (I am not sure if I have
to provide the application name somewhere.

Here is the command I put together:

DoCmd.TransferDatabase acExport, "dBase III", , acQuery,
"ClientRecordQuery", "ClientRecordDBF", 0, 0

I get the error: invalid argument. It would be nice if they actually
specified which arguments are bad...

Regards,
Nicolae

"Larry Linson" <bo*****@localhost.not> wrote in message
news:eq*****************@nwrddc03.gnilink.net...
"Nicolae Fieraru" wrote
> What I actually need is to export the
> query as a db3 table.


Instead of TransferText, you will use TransferDatabase.

Larry Linson
Microsoft Access MVP

Nov 13 '05 #4
Hi,

Thank you very much, this solution seems very easy to implement, however I
run into some problems, due to the design of the database (backend
application on a different server, and meantime somebody changed the mapped
address). It took me a while to discover the problem. I will test it soon

Regards,
Nicolae

"rkc" <rk*@yabba.dabba.do.rochester.rr.bomb> wrote in message
news:rr*******************@twister.nyroc.rr.com...

"Nicolae Fieraru" <no****@please.cxm> wrote in message
news:40********@duster.adelaide.on.net...
Hi All,

I have an access query which retrieves some record. I can export the results
of it as an excel document, using the function TransferText. What I

actually
need is to export the query as a db3 table. I've been suggested that

once I
export it to an Excel file, the user has to open the document and to
save it
as dbase III (.dbf) file
I expect I should be able to do this operation by code, using VBA.


You can export from a table or saved query to many formats using SQL.
The format for the query is

SELECT * INTO [dBase III;DATABASE=C:\].[customer] FROM [Customers]

dBase III is the export file type.
C:\ is the full path to the folder to be exported to.
customer is the file name minus the .extention
Customers is the name of the table or saved query.



Nov 13 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Fran Zablocki | last post by:
I have a process that exports an Access table to a comma-delimited text file. One of the fields that is exported shows the date it was exported, using the Date() function. In the Access table, the...
4
by: D | last post by:
I've created a report with many subreports of aggregate data. I want my client to be able to export this data to Excel to make her charts, etc. Only one problem: one of the fields is a "SchoolYear"...
2
by: Kenneth | last post by:
How do I remove the limitation in Access that deny me from exporting 24000 rows and 17 columns (in a query) into Excel? Kenneth
1
by: Big Time | last post by:
I'm exporting a large amount of data from one of my tables into a tab delimited text file. The problem is the fields that have date format come out in MM/DD/YY HH:MM:SS format when what I want is...
2
by: Mustufa Baig | last post by:
Hi everybody, I have an ASP.NET website where clients can view their monthly billings by selecting different options. One of the option is the way they want to see the report i.e. whether they...
1
by: Mustufa Baig | last post by:
I have an ASP.NET website where I am showing off crystal reports to users by exporting them to pdf format. Following is the code: ---------------- 1 Private Sub ExportReport() 2 Dim oStream...
6
by: sara | last post by:
I have what I think is a little strange...I have to get data from our payroll system into a specific format (fixed record length) as a .txt or .prn file only to upload to our 401k custodian. I...
0
by: =?Utf-8?B?ZGVuIDIwMDU=?= | last post by:
hi, I trying to export data display on a gridview that supports any language (like chinese, japanese, thai, french) shown here is chinese only. There is no problem exporting english language...
2
by: billelev | last post by:
Hi there, My question does not concern the exporting of data to CSV so much as the format of the exported data. The data to be exported consists of a time series of prices for a number of assets....
1
isladogs
by: isladogs | last post by:
The next online meeting of the Access Europe User Group will be on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, Mike...
3
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 3 Jan 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). For other local times, please check World Time Buddy In...
0
by: mar23 | last post by:
Here's the situation. I have a form called frmDiceInventory with subform called subfrmDice. The subform's control source is linked to a query called qryDiceInventory. I've been trying to pick up the...
2
by: jimatqsi | last post by:
The boss wants the word "CONFIDENTIAL" overlaying certain reports. He wants it large, slanted across the page, on every page, very light gray, outlined letters, not block letters. I thought Word Art...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....

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.