Recent content by jeanvliet2012

Hi VbaInet, I understood your saying. I did several tests between Access and Excel before I asked help here. Access database has 2 GB limitation. I was not able to put all the calcuation in Access. The performance was not good either. Thanks Jean

Thank you for your reply. Unfortunately, I have to use all the data in the Access table to do the analysis. I searched internet for Access and Excel related threads and could not find any resolutions. I assume that you can't just build a shell in Excl and leave the data in Access. Please let me...

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...

Hi, Thank you very much. It works. Jean

Hi pbaldy, thanks for the instruction. During the weekend, I did more research in internet. I re-did my SQL string. Here is it: zSQL = "UPDATE Supplier_Meeting_Planning SET [ID3] = '" & "=IF('Report - key'!$B$7=""ALL"",""ALL"",'2012 data'!B2)'" Here is the result from Debug.Print...

I am new to this and for some reason, I posted my reply last Friday but it is not displayed on the thread. Here is the the debug.print result: Run-time error '3075'; Syntax error (missing operator) in query expression"=IF('Report-key'!$B$7="ALL","ALL:,'2012 data'!B2)'. I can't use IIF in here...

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...

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.