Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by hlint09

  1. hlint09

    Problem Importing A Flat File Into Access 2007

    I am in NYC and those special characters are the standard delimiters for a broadly used database called Concordance from the company Lexis Nexis. Again, prior versions of Access use to import the data without major hassle but for some reason they are not importing it anymore and I am just...
  2. hlint09

    Problem Importing A Flat File Into Access 2007

    Thank you for answering chr(20) =  chr(254)=þ That is their representation and when Imported like that in Access 2003 and before the data get imported with no problems.
  3. hlint09

    Problem Importing A Flat File Into Access 2007

    I import a lot of data from A Concordance database (basically I import from text files). In previous versions of Access I can import the files with no trouble but the new one gives problem. The delimiters used are: Field delimiter: chr(20) Text Qualifier: chr(254) For example...
  4. hlint09

    Query Returns Correct Number Of Records...Buy Empty

    Thank you, I actually got this statement from the Access Query generator itself. Again that is just an example I am most interested in why when I have a few hundreed records it works and I can see my data but when I have thousands of records I still get my records but no visible data on them...
  5. hlint09

    Query Returns Correct Number Of Records...Buy Empty

    I do have a query that search in just one table. It is a very simple query. Ocacionally it works ok if my source table just contains a few records but if I have lets say 40,000 records I get as a result a table with the correct amount of records but all of them...empty! I am using Access...
See more

Part and Inventory Search

Back
Top