Import DBF data to a MySQL Table

Hi
I'm trying to sync a DBF file stored on my customer server with the
MySQL table on my server.
I'm still looking for an automatic way to do it, however, for now i'm
trying to find a way to create a small app that will help me do it
faster than manually.
My question is: how do I import the data from my DBF file to my MySQL
Server?
I already have the code to select data from the DBF, but can't seems to
be able to find a fast way to import it. I tried the way of inserting
each line, but its really slow since I have aroung 10,000 rows.
Any idea that would make the process faster ?
Thanks!
EricI think you bought a ticket to the wrong show. You should probably search
for a MySQL newsgroup...
<ericpoirier@.gmail.com> wrote in message
news:1149186767.242174.200480@.c74g2000cwc.googlegroups.com...
> Hi
> I'm trying to sync a DBF file stored on my customer server with the
> MySQL table on my server.
> I'm still looking for an automatic way to do it, however, for now i'm
> trying to find a way to create a small app that will help me do it
> faster than manually.
> My question is: how do I import the data from my DBF file to my MySQL
> Server?
> I already have the code to select data from the DBF, but can't seems to
> be able to find a fast way to import it. I tried the way of inserting
> each line, but its really slow since I have aroung 10,000 rows.
> Any idea that would make the process faster ?
> Thanks!
> Eric
>|||Yeah I know, new here and don't know how to delete posts.
Mike C# wrote:
> I think you bought a ticket to the wrong show. You should probably search
> for a MySQL newsgroup...
> <ericpoirier@.gmail.com> wrote in message
> news:1149186767.242174.200480@.c74g2000cwc.googlegroups.com...|||MySQL can import a comma separated value text file in a very short time. My
experience was 1.2 million records in about 10 seconds. If you can export th
e
MS SQL data as comma separated value file, then have a VB Script or program
to import the file into MySQL data base. There are several 3rd party
applications that will convert data from one database to another.
"ericpoirier@.gmail.com" wrote:

> Hi
> I'm trying to sync a DBF file stored on my customer server with the
> MySQL table on my server.
> I'm still looking for an automatic way to do it, however, for now i'm
> trying to find a way to create a small app that will help me do it
> faster than manually.
> My question is: how do I import the data from my DBF file to my MySQL
> Server?
> I already have the code to select data from the DBF, but can't seems to
> be able to find a fast way to import it. I tried the way of inserting
> each line, but its really slow since I have aroung 10,000 rows.
> Any idea that would make the process faster ?
> Thanks!
> Eric
>

Import Data

Hi everybody,
I want to import data from different server.

According to my system. when we sell anything to our customer we upload all the information to webserver from our local server. This job we are doing it manually right now. but i want to upload the information automatically. when my agents sell something and they submit as sell i want to send a copy of information to my webserver automatically. Is there any trigger which can insert data into different server or schedule which can import data from different server. Please help meread BOL about trigger,if u want immediate update to ur webserver.
Or u can write procedures and schedule it,check BOL schedule job.|||I try to steer clear of triggers which operate outside the scope of the database. Consider using the trigger to populate a staging table of changes, and then running a scheduled job to load those changes to your destination database. This setup is more tolerant of system disruptions.

Import Cobol files

Hi all,
I have a customer that needs to transform his old Cobol app into a VB or ASP
app.
I'm stuck here with his product listings that are all in .cob (cobol) files,
how can I import those into SQL or Excell ?
Thanks for your help
ManuYou cannot.
You will need a tool that translates the COBOL commands into VB or ASP.
There are a few companies out there that have that kind of a tool set you
might look at www.californiasoftware.com
Andrew C. Madsen
Information Architect
Harley-Davidson Motor Company
"Emmanuel Baeyens" <emmanuel.baeyens@.microplanet.be> wrote in message
news:ud3ZonlcEHA.4092@.TK2MSFTNGP10.phx.gbl...
> Hi all,
> I have a customer that needs to transform his old Cobol app into a VB or
ASP
> app.
> I'm stuck here with his product listings that are all in .cob (cobol)
files,
> how can I import those into SQL or Excell ?
> Thanks for your help
> Manu
>

Import Cobol files

Hi all,
I have a customer that needs to transform his old Cobol app into a VB or ASP
app.
I'm stuck here with his product listings that are all in .cob (cobol) files,
how can I import those into SQL or Excell ?
Thanks for your help
Manu
You cannot.
You will need a tool that translates the COBOL commands into VB or ASP.
There are a few companies out there that have that kind of a tool set you
might look at www.californiasoftware.com
Andrew C. Madsen
Information Architect
Harley-Davidson Motor Company
"Emmanuel Baeyens" <emmanuel.baeyens@.microplanet.be> wrote in message
news:ud3ZonlcEHA.4092@.TK2MSFTNGP10.phx.gbl...
> Hi all,
> I have a customer that needs to transform his old Cobol app into a VB or
ASP
> app.
> I'm stuck here with his product listings that are all in .cob (cobol)
files,
> how can I import those into SQL or Excell ?
> Thanks for your help
> Manu
>

Import and Export foreign characters (non-DBCS only)

Hi
I have a table which stores the customer information...There is a Customer
Address column defined as nvarchar(50)...Data for the table is imported
using DTS Bulk Insert from a Customer.dat file...
My question: -
1. What are the requirements for me to view the foreign characters (Arabic,
Turkish, German, Italian etc...) using an editor. What setup needs to be
done on the server where the files reside.
2. How do I make the .dat file as a unicode file ?
3. Can I see the foreign characters by a simple select in query analyzer?
4. What are the requirements to export the file to contain all those foreign
characters?
Ps: - Focus is not on DBCS characters (Kanji characters etc...)
Any help would be much appreciated....
Thanks in advance...
ImtiazSee below.
Steve Kass
Drew University
Imtiaz wrote:

>Hi
>I have a table which stores the customer information...There is a Customer
>Address column defined as nvarchar(50)...Data for the table is imported
>using DTS Bulk Insert from a Customer.dat file...
>My question: -
>1. What are the requirements for me to view the foreign characters (Arabic,
>Turkish, German, Italian etc...) using an editor. What setup needs to be
>done on the server where the files reside.
>
As long as the data is stored as Unicode, and the client is Unicode
compatible, all you need is Unicode fonts in your editor.

>2. How do I make the .dat file as a unicode file ?
>
I don't know about DTS, but I think that bcp will leave out the
two-byte Unicode byte-order marker at the beginning of the file.
You may need to insert the two-byte sequence FFFE yourself
so that other applications will handle it correctly. For importing
back to SQL Server, this might be the wrong thing to do, though.

>3. Can I see the foreign characters by a simple select in query analyzer?
>
Yes. Just make sure the font in your results window is a Unicode font
(Arial MS Unicode, for example).

>4. What are the requirements to export the file to contain all those foreig
n
>characters?
>
Just export as Unicode and it should be fine.

>Ps: - Focus is not on DBCS characters (Kanji characters etc...)
>Any help would be much appreciated....
>Thanks in advance...
>Imtiaz
>