.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Importing FREE Visual FoxPro 9.0 tables into SQL

Posted By:      Posted Date: August 30, 2010    Points: 0   Category :Sql Server
We have a vendor that provides us with any number of .dbf files (no memo fields, no indices0 which I need to import into SQL 2005. What is the exact syntax to import a VFP table that is NOT associated with a data container, or any specific database - but is a completely free, unrelated to anything else .dbf?   Thanks.

View Complete Post

More Related Resource Links

Creating a SSIS package to get data from free DBF (Visual FoxPro table) in 64 bit SQL Server


Hi everybody,

I originally posted in the wrong forum MSDN Thread

I'm trying to create (for test purposes) a package to load data from VFP table into SQL Server 64 bit. So far I can not figure out how to do it - I created DSN as outlined in Todd's blog, but I don't know what to do next.

Can someone please give me step by step instructions so I will know if it's possible or not? I was under impression it's not possible, but Todd's blog seems to suggest otherwise.

Thanks in advance.

Premature optimization is the root of all evil in programming. (c) by Donald Knuth

Naomi Nosonovsky, Sr. Programmer-Analyst

My blog

Visual FoxPro 7.0: Program Your Data with Powerful New COM, XML, and Web Services Support


Visual FoxPro 7.0 represents a significant improvement over version 6.0. There are many new features designed to support COM, XML, and Web Services. Now COM servers built with Visual FoxPro are more flexible and robust thanks to strong typing and the ability to implement interfaces from other type libraries. IDE features like the new object browser combine convenience and efficiency, and other language features such as event handlers and early binding to COM objects increase performance. Lastly, an enhanced session class plus several new XML functions make Visual FoxPro a great choice for Web application development.

Erik Moore

MSDN Magazine October 2001

ERROR [S1000] [Microsoft][ODBC Visual FoxPro Driver]Function name is missing ).


I Am Continiously Getting Error For Following Line Of Code, It Work  Fine In Other Database

Am I Doing Any Mistake

if (sh3itno != "" && dpsh3no != "")
                string queryy = "SELECT [CHEQNO] FROM [SH3MAST] WHERE (([CHEQDATE] = " + chqdate + ") AND ([FAVOUR] = " + favour + ") AND ([CHQTYPE] = " + ctype + ") AND ([TRSTN] = " + trstn + ") AND ([TRBANK] = " + trbank + ") AND ([SH3ITNO] = " + sh3itno + ") AND ([DPSH3NO] = " + dpsh3no + "))";
                OdbcCommand cmd3 = new OdbcCommand(queryy, connen1);
                string chqno =cmd3.ExecuteScalar().ToString(); (Here Iam Getting Error)
                tbl.Rows[i]["cheque no"] = chqno;
Stack Trace: 

[OdbcException (0x80131937): ERROR [S1000] [Microsoft][ODBC Visual FoxPro Driver]Function name is missing ).]
   System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode) +39
   System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, Strin

Importing Access 2010 tables to SQL Server 2008 R2

I'm trying to import a series of Access 2010 tables to Sql Server 2008 R2.  The Access import drivers are for *.mdb (which if I recall was the file extension for Access when I was a kid, and don't recognize the .accdb file extention).  Similarly, the Excel driver is for Excel 2003.  Isn't there a driver and method to import directly to SQL 2008 from Access 2010? SQL is installed on my server, but Access is not installed on the server.  When I copy the file onto the server and try and open it directly into SQL, I get a 'no editor installed' error. I can't get the 'upsize' wizard to work becuase it won't open the connection to SQL, even though I enter the userid and password of the SQL DB owner.  I get the following error: ===================================================== Connection failed: ============================================================= I have to say I'm stumped.  The rest of the Office 2010 suite works really well together - perhaps I'm missing something very simple? Thanks!     I guess I could export my tables as Excel 2003 and then import them using Integration Services, or install SQL Express on my laptop and 'upsize' to that instance, but SQL State: ‘0100’ SQL Server Error: 11004 [Microsoft][ODBC SQL Server Dirver][TCP/IP Sockets]ConnectionOpen (Connect()). Connection failed: SQL

Using ODBC to connect to foxpro tables to output to SQL tables

I'm new to SSIS and I have some foxpro tables that I need to import into SQL tables.  I think I need to use an ODBC since my tables are in foxpro 2.6.  I think I have the ODBC ready where I'm connected to the database, but not sure where to go from here.  Steps to setting up the ODBC may be useful just to make sure I did it right.  Any help is appreciated.

Free or open source UML add-ons to Visual Studio 2008

Hi there, Like to know any open source UML tool, which can be added to Visual Studio 2008 as add on   Thanks,

ASP Tables and Visual Studio 2008


I am working on a project that I have inherited that was built in VS 2008 using C# . Originally done as a Wizard it is now being changed to a single page form. When I first started I was able to drag and drop the textboxes and other elements around but then I had to change the tables from HTML to ASP so I could create them dynamically. After doing so I cannot click on anything inside the table when working in VS. Is this normal functionality? I'm relatively new to VS, ASP and C#

Importing multiple files to multiple tables in SSIS


I have a directory with 200+ txt files to import into SQL tables in a database. Each file name is the exact table name in the database(without the file extension, obviously). I am looping through each file with a for each loop and a variable is mapped and set in the source connection properties for the Expressions -> ConnectionString property, so each name will go into that variable without the file extensions, correct?  Now, I set the variable name to the table name in the destination for the table name under "Data Access Mode", but it is giving an error...do I have to assign variables to each part, (Connection String and Name)? Does anyone have a quick setup for this?



Importing huge tables from cross domain SQL servers



I am new in SQL server world and I have a problem in handling the import of lot of records (~12*10^6 records) between two SQL Servers that are in different domains.

I started using DTS through the import facility and I don't see lot of traffic on the LAN, so this seems a good approach, but it takes more than 4 hours to copy the entire temporary table from source SQL to destination SQL.

So I was thinking to linked server, and using sp_addlinkedserver I can hook the remote server. Now I would like to know if performing the select with the OPENQUERY is a better approach or if I could use a better solution.

My problem is that I should find a way for automating this activity every night, so every solution should be schedulable through SQL jobs, is this correct?

Thanks for any suggestion and help




Visual Web Developer 2010 Express - No more Free or a mistake?


I uninstalled VWD 2010 Express Beta2. Then installed latest Release(April 12th) via Web Platform Installer ...oh yes after installing XP Service Pack 3....

It all installed successfully and when I start the VWD 2010 express image comes up ....there is this fine text that says....

"For Evaluation Purpose Only"

"Use of this software should be limited to evaluation purpose only"

Being confused with that message I looked at Help->About VWD 2010 Express and right on top it says:

"29 days remaining"

So what's happening ????????? Did I install some wrong product... I don't think so...I used Web Platform Installer and yes it is "Visual Web Developer 2010 Express" and not a Professional Trial software.

With VWD 2008 it says "This product is licensed".

Anybody having any ideas...I am sure it is just some mistake (can I say it's a bug?)

Howto use Visual Studo 2008 to maintain SQL Server 2005 tables and stored procedures


I I have an ASP.Net web site I built using Visual Studio 2008.  I also have a SQL 2005 database I use with this web site.  I presently use MS SQL Server MManagement Studio Express to add / modify SQL tables, stored procedures, etc. 

But I want to now maintain my SQL datbase directly from my Visual Studo 2008 where I maintain my ASP,Net web site.  I have created a script from my QL DB that creates all my existing tables and stored procedures.  Can I somehow run this to create the necessary source files within VS 2008?


Importing SharePoint 2010 Site Definitions in Visual Studio 2010 (Visual How To)

Learn how to import a SharePoint 2010 site definition using Visual Studio 2010 and SharePoint Designer 2010 in this visual how-to video, overview, and code sample.

Video: Importing SharePoint 2010 Site Definitions in Visual Studio 2010

Watch this visual how-to video as you learn to import a SharePoint 2010 site definition using Visual Studio 2010 and SharePoint Designer 2010.

Sample: Importing SharePoint 2010 Site Definitions in Visual Studio 2010

Explore the code in this visual how-to article as you learn to import a SharePoint 2010 site definition using Visual Studio 2010 and SharePoint Designer 2010.

Free Code Snippets - ASP.NET

You Can Find Useful ASP.NET Related Posts on the above link.

Free Code Snippets - C#

Free C# Code Snippets

Visual Case Tool - UML Tutorial

The Class Diagram

The class diagram is core to object-oriented design. It describes the types of objects in the system and the static relationships between them.
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend