With my job I daily receive a .dbf file which has data from colums A to AI with the first row being the name tags e.g. ("Invoice Number" "Part Number" & etc.). Now, what I'm looking to do is somehow create a program or database where I can combine all of these and search this database for invoice numbers. But what makes this trickier for me is that I would really love to be able to push a button and export all rows which contain the same invoice number and create a file for just that invoice number.. What i'm talking about is shown below. Invoice_ Number Part Number 55555555 0001-12 55555555 0025-11 55555555 9985-02 11111111 1232-55 11111111 245-22 22222222 1223-11 (I'm not sure how to do this but I'd love to press a button and create a file which has all of the 3 rows for invoice # 55555555 or for any invoice Number I choose). Doe anyone have any idea how I could do this? I only really know how to use access & Visual basic but I have access to programs for any language. Any help would be greatly appreciated!!!

If you know how to use Access then you are half way there. Import the .dbf file into Access. You can even use the first row of data to create field names for you. Once you have the file in Access you can then use VBA to do whatever you want with the data. Or alternatvely import the file into Excel and use Excel's search and sort facilies to export the date you require into another spreadsheet or even an Access data file - or even use VBA to manipulate the data. Stuart

Do you know if there's any way I could combine these dbf files and removing the first column so the heading names don't show up in the data?

Dont you mean the firs row. Each row in a data file is a single record. When you import it into Access the first row can be used to create field names, otherwise field names have Field1, Field2, etc. With Excell you have the oportunity to designate the headers as as colum headers. If you dont want them, just delete them. Stuart