import dbf file to sql server 2005

there is a link out there for this but its referencing domething for
foxpro or something.
I use a product from ESRI the file are called shapefile(SHP)
its used as a mapping tool, with x,y's and stuff.
Anyway... I've export the data as a dbf, now I'd like to import this
data into a new empty table to be still created.
Will the wizard handle this. I really don't want to mess the database up
the dba would have a fit if you know what I mean.
OH very new to sql server sorry I was an Oracle brat before... so things
look really different to me, but hey just another tool right.
Any help would be great. THanks
Randy
*** Sent via Developersdex http://www.codecomments.com ***
Hi Randy
"randy davidson" wrote:

> there is a link out there for this but its referencing domething for
> foxpro or something.
> I use a product from ESRI the file are called shapefile(SHP)
> its used as a mapping tool, with x,y's and stuff.
> Anyway... I've export the data as a dbf, now I'd like to import this
> data into a new empty table to be still created.
> Will the wizard handle this. I really don't want to mess the database up
> the dba would have a fit if you know what I mean.
> OH very new to sql server sorry I was an Oracle brat before... so things
> look really different to me, but hey just another tool right.
> Any help would be great. THanks
> Randy
>
You may want to create your own sandbox database or possibly try this on
tempdb. If you have access to Enterprise Manager you can right click the
database and choose the Import Data option. As the datasource choose the
Visual Foxpro driver. dbf is the extension usually given to dBase and Foxpro
datafiles.
John

import dbf file to sql server 2005

there is a link out there for this but its referencing domething for
foxpro or something.
I use a product from ESRI the file are called shapefile(SHP)
its used as a mapping tool, with x,y's and stuff.
Anyway... I've export the data as a dbf, now I'd like to import this
data into a new empty table to be still created.
Will the wizard handle this. I really don't want to mess the database up
the dba would have a fit if you know what I mean.
OH very new to sql server sorry I was an Oracle brat before... so things
look really different to me, but hey just another tool right.
Any help would be great. THanks
Randy
*** Sent via Developersdex http://www.codecomments.com ***Hi Randy
"randy davidson" wrote:

> there is a link out there for this but its referencing domething for
> foxpro or something.
> I use a product from ESRI the file are called shapefile(SHP)
> its used as a mapping tool, with x,y's and stuff.
> Anyway... I've export the data as a dbf, now I'd like to import this
> data into a new empty table to be still created.
> Will the wizard handle this. I really don't want to mess the database up
> the dba would have a fit if you know what I mean.
> OH very new to sql server sorry I was an Oracle brat before... so things
> look really different to me, but hey just another tool right.
> Any help would be great. THanks
> Randy
>
You may want to create your own sandbox database or possibly try this on
tempdb. If you have access to Enterprise Manager you can right click the
database and choose the Import Data option. As the datasource choose the
Visual Foxpro driver. dbf is the extension usually given to dBase and Foxpro
datafiles.
John

import dbf file to sql server 2005

there is a link out there for this but its referencing domething for
foxpro or something.
I use a product from ESRI the file are called shapefile(SHP)
its used as a mapping tool, with x,y's and stuff.
Anyway... I've export the data as a dbf, now I'd like to import this
data into a new empty table to be still created.
Will the wizard handle this. I really don't want to mess the database up
the dba would have a fit if you know what I mean.
OH very new to sql server sorry I was an Oracle brat before... so things
look really different to me, but hey just another tool right.
Any help would be great. THanks
Randy
*** Sent via Developersdex http://www.developersdex.com ***Hi Randy
"randy davidson" wrote:
> there is a link out there for this but its referencing domething for
> foxpro or something.
> I use a product from ESRI the file are called shapefile(SHP)
> its used as a mapping tool, with x,y's and stuff.
> Anyway... I've export the data as a dbf, now I'd like to import this
> data into a new empty table to be still created.
> Will the wizard handle this. I really don't want to mess the database up
> the dba would have a fit if you know what I mean.
> OH very new to sql server sorry I was an Oracle brat before... so things
> look really different to me, but hey just another tool right.
> Any help would be great. THanks
> Randy
>
You may want to create your own sandbox database or possibly try this on
tempdb. If you have access to Enterprise Manager you can right click the
database and choose the Import Data option. As the datasource choose the
Visual Foxpro driver. dbf is the extension usually given to dBase and Foxpro
datafiles.
John

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
>