This is a multi-part message in MIME format.



------=_NextPart_000_0002_01C19DD7.ED997070

Content-Type: text/plain;

	charset="iso-8859-1"

Content-Transfer-Encoding: 8bit



perhaps you have in the table some blank lines..

remove them, and try again to change UID fields...

HTH

  -----Messaggio originale-----

  Da: Kamjohn Youthjug [mailto:vze2vppf@v...]

  Inviato: marted́ 15 gennaio 2002 18.04

  A: ASP Databases

  Oggetto: [asp_databases] FW: SQL importing question







  -----Original Message-----

  From: Kamjohn Youthjug [mailto:vze2vppf@v...]

  Sent: Tuesday, January 15, 2002 8:54 AM

  To: ASP Databases

  Subject: [asp_databases] SQL importing question





  Hi everyone

  I was given a text file db that consited of the following fields:



  JTG 001|JANET JACKSON HITS!|POCKET SONGS|RHYTHM &

BLUES|VOCAL|CDG||1|JACKSON, JANET|AGAIN|3|46|C|29.98|JACKSON,

JANET|Y|11/1/00

  JTG 001|JANET JACKSON HITS!|POCKET SONGS|RHYTHM &

BLUES|VOCAL|CDG||17|JACKSON, JANET|WHEN I THINK OF YOU|4|18|A|29.98|JACKSON,

JANET|Y|11/1/00



  I used xcel to import the information so the field can be imported to sql

correctly. It looked like this.



  --------------------------------------------------------------------------

----------------------------------------------------------------------------

----------------------------------------------------------------------------

        UID CatalogNum AlbumTitle Manufacturer SongCategory MusicType

MediaType TrackNum Artist SongTitle Minutes Seconds Key Price AlbumArtist Y

ReleaseDate Media AlbumCover Details

        1 JTG 001 JANET JACKSON HITS! POCKET SONGS RHYTHM & BLUES VOCAL CDG

1 JACKSON, JANET AGAIN 3 46 C 29.98 JACKSON, JANET Y 11/1/2000

        2 JTG 001 JANET JACKSON HITS! POCKET SONGS RHYTHM & BLUES VOCAL CDG

17 JACKSON, JANET WHEN I THINK OF YOU 4 18 A 29.98 JACKSON, JANET Y

11/1/2000

        3 JTG 001 JANET JACKSON HITS! POCKET SONGS RHYTHM & BLUES VOCAL CDG

16 JACKSON, JANET WHAT HAVE YOU DONE FOR ME LATELY 3 31 Ebm 29.98 JACKSON,

JANET Y 11/1/2000

        4 JTG 001 JANET JACKSON HITS! POCKET SONGS RHYTHM & BLUES VOCAL CDG

15 JACKSON, JANET TOGETHER AGAIN 4 2 C-Eb 29.98 JACKSON, JANET Y 11/1/2000



  --------------------------------------------------------------------------

----------------------------------------------------------------------------

----------------------------------------------------------------------------

---

   The UID field I input it myself. and the rest of the fields were

generated when i imported the text file. Here's my issue though. I imported

the excel file to SQL

  --------------------------------------------------------------------------

----------------------------------------------------------------------------

----------------------------------------------------------------------------

--

   1 JTG 001 JANET JACKSON HITS! POCKET SONGS RHYTHM & BLUES VOCAL CDG 1

JACKSON, JANET AGAIN 3 46 C 29.98 JACKSON, JANET Y 11/1/2000

   2 JTG 001 JANET JACKSON HITS! POCKET SONGS RHYTHM & BLUES VOCAL CDG 17

JACKSON, JANET WHEN I THINK OF YOU 4 18 A 29.98 JACKSON, JANET Y 11/1/2000

   3 JTG 001 JANET JACKSON HITS! POCKET SONGS RHYTHM & BLUES VOCAL CDG 16

JACKSON, JANET WHAT HAVE YOU DONE FOR ME LATELY 3 31 Ebm 29.98 JACKSON,

JANET Y 11/1/2000

   4 JTG 001 JANET JACKSON HITS! POCKET SONGS RHYTHM & BLUES VOCAL CDG 15

JACKSON, JANET TOGETHER AGAIN 4 2 C-Eb 29.98 JACKSON, JANET Y 11/1/2000

  --------------------------------------------------------------------------

----------------------------------------------------------------------------

----------------------------------------------------------------------------

----



  and it turned out like the above, which is great. I tried changing the UID

field to a unique identifier but it wouldn't let me. Saying it can't set it

to NULL identifier. So basically I can't get it to increment when i add new

records. it justs puts a <NULL> value in the UID field. Can anyone help with

this?



  Best Regards

  -Kamjohn Youthjug




$subst('Email.Unsub').