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