By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,836 Members | 1,876 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,836 IT Pros & Developers. It's quick & easy.

Need help reading Lotus Approach files

P: n/a
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
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.