[Webinar] Streamline your web hosting managementRegister Today


Convert DBF to MDB via VB

Posted on 2000-01-14
Medium Priority
Last Modified: 2008-03-17
How to add data from DBF database to ACCESS database if not exists in access database... check all fields value to prevent that record already exitsts

i was tray with SQL querys but any error has occrues ...
SQL query sintaxs that i use is
SELECT * FROM access_table WHERE field1=value1 AND field2=value2 AND ...

don't use any data field pointer, autonumbering field or id's to check data

also i must say that in DBF Database exists fields with any empty records, dbDate,dbText,dbDouble type fields with empty value... and soon...

please send me source code or any sample with this ... to email bokinet@infosky.net
Question by:bokikg
  • 2
  • 2

Expert Comment

ID: 2362357
I am sorry. I did not understand. Can u please reframe the question with a little bit of grammar change.

Author Comment

ID: 2364908
how to transfer all data from any dbf database to access database ...
null value for date type of fields in dbf database are present...

Expert Comment

ID: 2376607
bokikg, create an Access table with the same structure as the FoxPro table and then create a recordset to read the data from the FoxPro table and then insert it into the Access table. You can also asign the field values to variables and check for null values.

Author Comment

ID: 2376659
i tray that but when i have any empty record in dbf database (field is date type) error has occrud... because field is empty

Accepted Solution

jackg earned 400 total points
ID: 2390811
okay, if you use a variant variable to hold the dates from foxpro then vb will accept NULL values.

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Enums (shorthand for ‘enumerations’) are not often used by programmers but they can be quite valuable when they are.  What are they? An Enum is just a type of variable like a string or an Integer, but in this case one that you create that contains…
Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…
Suggested Courses

607 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question