![]() Once done, click Close & Load at the top left on the menu to import the data into a new worksheet. Click the grid icon in the top-left corner of the data grid and then select Use First Row as Headers (assuming the first row contains column names). Click the Edit button at the bottom of the screen.Ī new window will appear with option to edit the data prior to import. This will be the same file you currently have open.Īn import window will be displayed showing the data from the. CSV file to your computer and then open it.ģ) Select the Data tab from the menu ribbon and then click From Text/CSV.Ī window will appear which will allow you to select the file. The steps outlined below will guild you through the process of converting a. Often times these can be difficult to read and need to be converted to something more legible, such as a standard Excel. ![]() The most common scenario I see is data coming over as a comma delimited. ![]() However, there may be times where you are getting data from an outside source where you have limited control over the format of the file. ![]() These days you can generally export any file format you need from systems such as SQL Server Reporting Services or even directly from a SQL Server Agent Job. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |