Duplicate Entries

[Sameer]

I receive data in Excel format and import them to Access.After updating records in Access( i.e.Deleting expired records thru macro), I export them back to excel.

Problem:
The program generates blank spaces for deleted records and also for remaining records, it generates duplicate records i.e. same record is shown twice or sometime thrice though I imported it only once.
Can any one help to eliminate these blank lines and also to get rid of duplicate records.
Thanks

 

[neileg]

Number of thoughts
1) Why are you importing, then exporting. You could link the Excel file to Access and delete the records in situ.

2) How are you exporting the data? From a query or a table? Does the object in Access have these problems or just the exported file.

3) Is it not possible to do the updating in Excel. How complex is it?

 

[Sameer]

Thanks for your response...

Importing is done basically of the spreadsheets received from various sources on a continues basis.Once received it is saved in a particular name and then imported to Access.

Exporting is done to four different locations as not everybody viewing it from those location has Access.

The exporting is done of the table through macro.

The duplicate records are there in table itself which is exported.This problem is in the object file itself and therefore in the transferred file.

Updating in excel is also not for the very simple reason, that the person responsible to update the records has very little knowledge to handle Access or Excel...I have developed it mostly based on click and go basis to make it easy for the person updating it.

 

[neileg]

I'm still struggling a bit to understand where the problem is, but here goes.

You are importing some data that contains duplicate lines and blank lines. You want to convert these to a list of unique records with no blanks.

Create a query based on your inported data. Add all the fields to the query grid. In the criteria row type Is Not Null. In the query properties set Unique Values to yes.

That, I think, gives you what you want.

 

[Sameer]

Thanks, Neil....works great for me....appreciate your help.