inserting numbers into table

W

wessman

Every week, I am handed an Excel file with the following format:

Col A Col B
Row 1 1 50009876
Row 2 50006549
Row 3 2 50004531
Row 4 50004563
Row 5 50007894
Row 6 3 50006547
Row 7 4 50004561
Row 8 50004512

....notice that Row 3 has a NULL value in cell A2. That is because
cells B1 and B2 are grouped under the value "1"; just as cells B3, B4
and B5 are grouped under "2"; B6 grouped under "3"; and B7 and B8
grouped under "4".

I need to import this Excel sheet into Access and then change the
above example data to the following, maintaining the sorted order:

Col A Col B
Row 1 1a 50009876
Row 2 1b 50006549
Row 3 2a 50004531
Row 4 2b 50004563
Row 5 2c 50007894
Row 6 3a 50006547
Row 7 4a 50004561
Row 8 4b 50004512

....any ideas on how I might achieve this?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need some PWA help 0
inserting table data from a Word document into an Access table 0
Page numbering with Merged Document and IF statements 1
Look Up Formula With Veried Search Range 2
Lookup Formula 4
Staggered filter on Excel 0
Group rows based on indention of string in a column 0
Arriving at totals 2

Top