Hello again,

You say that the database import process only allows for the "Name" row and 5
> rows after that. Can't you make it 9 rows after the name? Then you can be assured of the row segmentation.

What type of "database import process" are you using?

If the source file is a .csv or .txt or .dat and not an application
proprietory document like .xls or .doc or .pdf then you can import it with
excel either file open method or Data > Import external data >..

You can then determine the fields yourself.

Otherwise I could write an import file program that reads each line into
specific cell
locations. I need to look at the file first to determine its layout ie
delimiters ...


Example1: "blah,blah,blah"

Example2: "blah" "blah" "blah"

Example3: blah,blah,blah

Example4: blah blah blah

etc......


send to excelmarksway@yahoo.com.au

see my stuff at:
http://www.geocities.com/excelmarksway

- - Mark







"Mr_Flibble" wrote:

> Yes, that database import process only allows for the "Name" row and 5
> rows after that. The 6th row needs to be the "Name" row and so forth. I
> realise this means discarding CODES fields, but it's the only way.
>
> What I think would work would be a macro that could automatically count
> the blank/empty cells between the Name rows and then delete/insert rows
> (which may not be completely empty) before the next Name row to make
> them 6 rows apart. Are there some functions that sound like they could
> do this?
>
> A little more background to the dilemma is that I was given the
> spreadsheet with all the existing data in it. If there's some way of
> correctly formatting it then I should be able to use an existing import
> tool to put it into Access where it will only be used for reference
> purposes (ie users will not enter any extra data).
>
> I would be really grateful for any suggestions......
>
>