November 17, 2009 at 8:42 am
Hello all:
Here is the situation:
I was just assigned to this new project...12 centers will FTP their data in a Zipped Folder that has .DBF and .FPT files in it...They then want all the data from those files consolidated into one sql server database table...However when I went to create the db, I needed to see how the file was structured so I would know how to set up my table and when I tried opening one of the .DBF files, the window popped up saying it didnt know what to open it with - so I tried Notepad, Wordpad, MS Word, MS Access, and SQL Server...It would open up but it was in such a format that I couldnt tell what it was so I dont know how to proceed...Can anyone help me? I tried googling and some the things I read said it could be opened in MS Access but when I tried to do it said that the External Table was not in format...I need to know how those files are set up so I can be able to get started with this project! Any help is appreciated...if I have not given sufficient info, just ask and I will go into more detail!
Somebody had mentioned to me to use SSIS and use an OBDC connection but when i start a new SSIS project and go to get a new connection I didnt see ODBC...I saw OLE DB Connection but nothing to do with OBDC or Dbase...Does anyone have any suggestions???
Thanks
November 17, 2009 at 9:55 am
Have you tried opening it up in FoxPro?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 17, 2009 at 9:59 am
I dont have FoxPro...We were thinking about that or File Maker Pro! But I dont have either so I was seeing if there was another way to open the file!
November 17, 2009 at 11:08 am
One possibility is if you have MSDN. You could download foxpro from the MSDN site.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 18, 2009 at 7:23 am
This is a duplicate post and there are other answers here.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply