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

Programaticly Save As dBASE-5 format

Hello all,

I'm (still) using A97.

I'd like to save/export a table (a link to a SS2000 table) in dBASE 5
format, programaticly using VBA. Is that possible? I'm currently doing
it by hand but I'd like to automate this process.

I looked at:

- DoCmd.RunCommand acCmdSaveAs
... but it simply brings the Save As... dialog
- DoCmd.TransferText
... but didn't find a way to export it in dBASE 5 format

Any solution, suggestion, help would be appreciated.

Thanks for your time.

Yannick

Aug 24 '06 #1
2 2413
On 24 Aug 2006 08:19:59 -0700, "Yannick Turgeon"
<ve********@gmail.comwrote:

DoCmd.TransferDatabase

-Tom.
>Hello all,

I'm (still) using A97.

I'd like to save/export a table (a link to a SS2000 table) in dBASE 5
format, programaticly using VBA. Is that possible? I'm currently doing
it by hand but I'd like to automate this process.

I looked at:

- DoCmd.RunCommand acCmdSaveAs
... but it simply brings the Save As... dialog
- DoCmd.TransferText
... but didn't find a way to export it in dBASE 5 format

Any solution, suggestion, help would be appreciated.

Thanks for your time.

Yannick
Aug 25 '06 #2
Thanks. Works fine! :o)

On 24 Aug 2006 08:19:59 -0700, "Yannick Turgeon"
<ve********@gmail.comwrote:

DoCmd.TransferDatabase

-Tom.
Hello all,

I'm (still) using A97.

I'd like to save/export a table (a link to a SS2000 table) in dBASE 5
format, programaticly using VBA. Is that possible? I'm currently doing
it by hand but I'd like to automate this process.

I looked at:

- DoCmd.RunCommand acCmdSaveAs
... but it simply brings the Save As... dialog
- DoCmd.TransferText
... but didn't find a way to export it in dBASE 5 format

Any solution, suggestion, help would be appreciated.

Thanks for your time.

Yannick
Aug 25 '06 #3

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

Similar topics

4
by: Matt Young | last post by:
I've been tasked with integrating an older management system based on DBF files with my snappy new ASP application to provide users of the ASP application with real-time data from the management...
2
by: Ivan | last post by:
Hi, SQL Server 2000 SP3 Windos 2000 Server SP4 I have a DTS package that imports data from a dBase IV databse with files located in two folders (dBF1 and dBF2). I use a transform data task...
10
by: level8 | last post by:
I would like to see a Clipper/dbase DBF file as a table in SQL Server 7.0. How can I SELECT rows from DBF file? Should I use OLE DB Provider or ODBC, and how?
3
by: osmethod | last post by:
Hello, I'm using Access 97 and I would like to save a query but, give the user the option of the type (e.g. Txt, Xl, Mdb, dbf) etc. I see this functionality in the Save/Export, Save as...
5
by: Patrick F | last post by:
I got a link to my .aspx page, when the link is pressed i want the user to be able to download what the .aspx sends to it. Inside my .aspx page i have a string called strPage, i want that strPage...
4
by: Martin Arvidsson | last post by:
Hi! I have used the SqlCommand and DataReader to read data to a DataSet This dataset is the used to set the properties; DataMember and DataSource of the DataGridView. Now what i want to do is...
2
by: Songyang | last post by:
I'm new to this group. In my company in Japan, we have been using dbase for almost 20 years, and we are now switching to foxpro. Dose anybody here has experience in converting dbase programs from...
10
by: schneider | last post by:
I'm looking for a way to programaticly call a method from a different object and associate the two objects at runtime. Example: Object A exist and is unknow, I want object B to be able to call a...
8
by: paquer | last post by:
I'd like to provide an Export Function from my forms, where the User can choose the File name & save location Although I cannot get the "Save As" dialog box to open properly from access. What is...
2
by: bcbrock | last post by:
I am trying to figure out how to query some data out of a dbase IV (.dbf) file sitting on a remote server from my MySQL/PHP/Web Server. Both servers are Windows Server 2003 SP2. My...
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
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
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
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,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
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...
0
tracyyun
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...

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.