Opening a CSV file in Excel in the normal way will cause you to loose leading zeros on numbers such as zip codes.Option 1: Use the K2 Odata Feed in K2 Five 5.2 or later with Microsoft Excel to export the records and you can later migrate data from CSV file to Sharepoint. Hi JulieBird, Perhaps, you can try the following approaches. This shell script simply connects to sqlplus and fires the SELECT query to get the requisite data. Once the script is run, the file emp.csv contains the the data of the entire table.In the interest of allowing you to import your files more quickly, or so that you can edit the files before you send them to use for import, you will find instructions below on how to convert a TXT file into a CSV file.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |