473,327 Members | 2,103 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,327 software developers and data experts.

Need help reading Lotus Approach files

Friends:

I'm doing some work for a small government client centralizing data from
a bunch of little databases into SQL Server. Everything's been easy
except for reading in data from a set of small, single-table Lotus
Approach files which the client updates periodically and which I need to
read into SQL Server programmatically.

I've been trying to do this using VB.NET but can't figure out how to do
it. I'm running VB.NET 2003 Enterprise.

From my reading of newsgroup posts there are different opinions, neither
of which I've gotten to work: one is to use the built-in ODBC DBase
driver (which I can't get to work) and another is to use the IBM ODBC DB2
driver (which I can't find anywhere for free download on the Internet, so
I can't even try).

The Approach file uses a ".DBF" extension and, surprisingly, when I try
loading them into Excel (Office 2003 version) using "File/Open" they open
successfully.

I just need to be able to read the Lotus Approach files programmatically
using VB.NET. Anyone got any suggestions / appropriate drivers /
connection strings / links that could help me?

Thanks in advance! - Dave

Nov 21 '05 #1
0 1245

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

Similar topics

5
by: NickBlooruk | last post by:
Hello, I have successfully linked a Lotus Notes server to our SQL Server database using an ODBC connection. This works fine when wanting to select records eg openquery(LOTUSNOTES2, 'select *...
7
by: pillip | last post by:
I am trying to use fopen and fget to input two files and then output them into one file. Each input file has two columns and 20 rows, however since the first column in each input file is same (...
2
by: JJBW | last post by:
Hi Does anyone know how I make a connection to a Lotus Notes database to extract address based upon a parameter e.g. customer id ? Best Regards, JJBW
1
by: apondu | last post by:
Hi, i was searching for some information about Lotus files and C#.Net. I wanted to know whether it is possible to open and read the content from the Lotus files using C#.Net. If anyone does know...
1
by: Joe | last post by:
HI Has anyone been able to work with lotus notes automation classes??? Can you post sample code of how to use these classes. I have setup in VB but I am not able to port to C# This is what I...
0
by: elgemcdlf | last post by:
I have a small db built with Lotus Approach that polls servers and catalogs the responses. I have now run into one that uses a Web Service for the data I desire. Below is the WSDL file along with the...
20
by: timmg | last post by:
You know, I've had so much fun reading the thread on lookup field's subservience to the Dark One that I thought I'd provoke another, ah, polite discussion on the topic of Macros. I've always...
5
by: Justin | last post by:
Here's my XML: <?xml version="1.0" ?> <AppMode Type="Network"> <CurrentFolder Path="c:\tabs"> <Tabs> <FilePath>tabs\Justin.tab</FilePath> <FilePath>tabs\Julie.tab</FilePath> *****There could...
0
by: Kristoph | last post by:
Hello, I would like to send an Access report as text in the body of a Lotus Notes email. Currently I am using DoCmd.SendObject which sends the report as a text attachment just great! But,...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...

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.