|
|
Rank: Newbie
Groups: Member
Joined: 2/8/2008
Posts: 4
Points: 0
|
Hello,
I have some csv files with text fields including the new line characters.
How can I import these?
Using the standard "\n" or "\r\n" does not work.
|
|
Rank: Administration
Groups: Administration
Joined: 9/11/2006
Posts: 605
Points: 649
Location: Enghien Les Bains, France
|
Actually, there is no work-around for this problem.
|
|
Rank: Newbie
Groups: Member
Joined: 2/8/2008
Posts: 4
Points: 0
|
Ok I'll forget the csv files.
I have access to the remote db only via myLittleAdmin and myLittleBackup (and asp.net). On our local workstation we have Enterprise Manager but I can't connect it to the remote db.
Is it possible to create with my local Enterprise Manager a file that can be restored to the remote db with myLittleBackup restore functionality?
What is the file format used by myLittleBakcup?
|
|
Rank: Administration
Groups: Administration
Joined: 9/11/2006
Posts: 605
Points: 649
Location: Enghien Les Bains, France
|
JX wrote:Is it possible to create with my local Enterprise Manager a file that can be restored to the remote db with myLittleBackup restore functionality? You can create the backup with your local Enterprise Manager or SQL Server Management Studio. JX wrote:What is the file format used by myLittleBackup? myLittleBackup uses the standard MS SQL backup format. Which means you just need to create your backup with your favorite local SQL Server Management Tool (EM, SSMS, etc.) and then use myLittleBackup to upload and restore this backup over your hosted database. Have a look at http://www.mylittlebackup.com/mlb/en/spotlight.aspxIt explains the main steps.
|
|
Rank: Newbie
Groups: Member
Joined: 2/8/2008
Posts: 4
Points: 0
|
Perfect.
Thank you very much.
|
|
|
Guest |