Question import DIF file data in SQL database

[DandanePallavi]

Hi all,

I want to import data in DIF file into SQL database.

then I want to process that data using that table.

Kindly help me out to get DIF file into Database.

Thanks in Aadvance

Pallavi

 

[ss7thirty]

I am not sure that importing this type of data to Microsoft SQL Server is supported. I am assuming that your DIF is an openoffice spreadsheet. You may want to transfer the data to some sort of csv, txt, xls, etc. Or a format that would be supported by the import then you can just do it through the wizard. I am not sure what the contents of a DIF looks like which may also help me get you a better answer because there may be some quick way to run through a dif with code and run insert statements or something like that. I am not sure if this is a one time import as well or a regular thing. All of those thing would control how I would go about getting the data into sql.