Import table from notepad to SQL server 2005

[Raman Pahwa]

I have a notepad with different fields.I want to import it in sql 2005.
In Sql 2005,there are rows and columns.
Just want to know which option should select for rows and column delimiters.

[ck9663]

If this is one time, just use the IMPORT wizard. If not use BCP, BULK INSERT or OPENROWSET

-- CK

[Raman Pahwa]

When i am using Import wizard,I am getting all the fields in single column.there are options for rows and column delimiter in which CR,LF,tab,(CR,L F),vertical bars etc .which option i should use so that different fields should be in different columns

[ck9663]

That would depend on your column delimiter.

Could you post some sample data?

-- CK

[Raman Pahwa]

sending you the sample data .copy this in notepad n then try. there are 5 columns and 4 rows.

12 99 FD 8/6/2008 0:00 9/6/2008 0:00
23 99 FD 8/6/2008 0:00 9/6/2008 0:00
34 99 FD 8/6/2008 0:00 9/6/2008 0:00
45 99 FD 8/6/2008 0:00 9/6/2008 0:00

if u have no issue,Could u plz tell me when u b online,so that i can solve my problem ASAP.

Thanks

[ck9663]

Choose delimited. Your delimiter could be space or tab.

-- CK

[Raman Pahwa]

Hi,


But there is no option of space in sql 2005.plz suggest something else.

[ck9663]

You might be forced to just use a fixed-length and specify the length of each column.

-- CK

[Raman Pahwa]

but the length of all the columns is not same.

Then wat to do???

[ck9663]

A fix length means your column's content have the same length. It does not mean all columns have the same length. You can define length of each column on the wizard.

-- CK

[Raman Pahwa]

Its still not working becoz there is not such option.plz help me online if u can

[ck9663]

1. Right Click on your db

2. Choose Task-Import Data

3. Click browse and locate your data file.

4.Format: Delimited

5. Header Row Delimiter: {CR}{LF}

6. Click Columns

7. Click Reset Columns

8. In Column Delimeter, put space (not the word 'space', but press your spacebar)

9. Click Refresh


-- CK

[Raman Pahwa]

Thanks, i have reached till the end of my problem.

but the option RESET COLUMN is disabled

[ck9663]

No problem with my test.

Try changing the file name. It will say that the wizard will reset. Confirm it. Then change it back to your original file.

-- CK

[radhakrishna04]

That would depend on your column delimiter.

Could you post some sample data?

-- CK

pl;s send me reply for this Import table from notepad to SQL server 2005