Search results

  1. J

    Linking Access Table with Excel Worksheet

    I have a big Access table with 900,000 rows, this table may grow beyond 1,000,000 records within 2-3 months. I would like to use Excel to read the table but I don't want to download the data to Excel. I know when you link Access and Excel, you will download the data to Excel. Is there a way to...
  2. J

    Access Update SQL run time error 3075

    Could someone tell me what's wrong with my zSQL string? I am working on it for 2 days and got no where. I want to put a IF statement (=IF('Report - key'!$B$7="ALL","ALL",'2012 data'!B2)) to a ACCESS Text field using SQL Update. Here is my code: Dim zSQL As String Dim zmsg As String Dim...
  3. J

    Jean V, Chicago, IL, USA

    Hello everybody, I am so glad to join this forum. I am a programmer for more than 10 years in AS/400 and Unix. Recently, I am using Excel and Access heavly and found out that I need a lot of help from the experts.
Back
Top Bottom