Data range

  • Thread starter Thread starter Dan
  • Start date Start date
D

Dan

Hi,
I'm using log file as source file for my access querie. Log file contains a
lot of information and it is bigger than 10 MB (queie needs 5+ sec for final
result).

How can setup querie that it search just first 1000 lines of log file?
(there is more than 40.000 lines).

Thnx!
 
5 seconds sounds VERY much to long of time for such a small file.

Does the have a index on it?

If the file has autonumber id, then to get the last 1000 records, try:

select top 1000 * from tblMainClient order by id desc
 
You must log in or register to reply here.

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

Delete lines from txt file 6
Database Import Duplicate Issue 0
Access Error Message "There is no object in this control" 3
Using OutputTo Excel - Can I get it to make multiple worksheets 3
SEC Audit Reqirements For Importing Data? 1
Embed Webpage and Code for Click 1
How to import data from text file 1
Count Conditional formating data 3

Back
Top