data conversion from spreadsheet to database

Reply Subscribe

Thread Tools

Search this Thread

14 November 2007, 02:31 PM

spectrum48k

Scooby Regular

Thread Starter

Join Date: Feb 2006

Posts: 2,519

Likes: 0

Received 0 Likes on 0 Posts

data conversion from spreadsheet to database

Normally it would be a problem but one spreadsheet has 2 thousand rows of data where product information is spread over 2 rows...

eg. I've simplified it...

row 1 = product code, description
row 2 = product price

row 3 = product code, description
row 4 = product price

and so on...

what's the best way to convert this into a database ? Ideally I need a method to combine every 2 rows into a single row in the database

Reply Like

14 November 2007, 03:00 PM

john_s

Scooby Regular

iTrader: (1)

Join Date: Dec 2002

Location: Preston, Lancs.

Posts: 2,977

Likes: 0

Received 0 Likes on 0 Posts

Macro in Excel to move the data onto a single row for each entry?

Then it's just a straightforward import into the database.

Reply Like

14 November 2007, 03:06 PM

spectrum48k

Scooby Regular

Thread Starter

Join Date: Feb 2006

Posts: 2,519

Likes: 0

Received 0 Likes on 0 Posts

ooh macros - never used em.

thanks for the advice, will check it out

Reply Like

14 November 2007, 03:37 PM

spectrum48k

Scooby Regular

Thread Starter

Join Date: Feb 2006

Posts: 2,519

Likes: 0

Received 0 Likes on 0 Posts

how do you enter this formula in Excel ?

if J6 starts with "L" then I7=J6

so far using the formula wizard I've got

=IF(I6="L*",J5=I6,"-")

but the ="L*" is clearly wrong

Last edited by spectrum48k; 14 November 2007 at 03:42 PM.

Reply Like

14 November 2007, 03:55 PM

bob269

Scooby Regular

Join Date: Mar 2003

Posts: 2,654

Likes: 0

Received 1 Like on 1 Post

Quote:

Originally Posted by spectrum48k

how do you enter this formula in Excel ?

if J6 starts with "L" then I7=J6

so far using the formula wizard I've got

=IF(I6="L*",J5=I6,"-")

but the ="L*" is clearly wrong

=IF((LEFT(I6,1))="L",I6,"-")