Rank: Newbie
Groups: Member
Joined: 6/5/2007
Posts: 6
Points: 0
|
I use myLittleAdmin for SQL Server 2005 3.1 on my webhost - LunarPages (version 3.1d release 0023 build 2580)
Select a table and then click on 'Open Table' to view the data.
There are 3 icons that allow you to export the data, as XML, as XLS and as CSV.
Does the export as CSV option have an option to specify that the column names are written to the first line of the file? If not, can this be implemented?
Also, there is an option to import a CSV file (Tools / CSV Import Wizard). Is there an option to import an XML file or an XLS file?
Also, is there an option to export all tables, stored procedures etc. as XML / XLS / CSV files?
|
Rank: Administration
Groups: Administration
Joined: 9/11/2006
Posts: 605
Points: 649
Location: Enghien Les Bains, France
|
swdev1 wrote:
Does the export as CSV option have an option to specify that the column names are written to the first line of the file?
No. swdev1 wrote:
Also, there is an option to import a CSV file (Tools / CSV Import Wizard). Is there an option to import an XML file or an XLS file?
No. swdev1 wrote:
Also, is there an option to export all tables, stored procedures etc. as XML / XLS / CSV files?
No. Sorry for so much no in a single answer 
|
Rank: Newbie
Groups: Member
Joined: 6/5/2007
Posts: 6
Points: 0
|
thanks for the quick reply.
Are there any plans to add these options? I feel they would help in administering the database.
|