问题描述
我需要从SQL数据库输出3 x 86400条记录并将其写入工作表(我尝试逐个写入记录但是它需要难以置信的长时间来处理。所以我创建了3个数据源并使用VBA宏生成以下代码和
然后我将这些代码嵌入到我的VB6应用程序中。它与常量日期工作正常但我只是不能使用变量。
I needs to output 3 x 86400 records from a SQL database and write it to a worksheet (I tried write the record one-by-one but it takes unbelievable long time to process. So I created 3 data sources and using the VBA Macro to generate the below code and then I embed those code to my VB6 application. It is working fine with the constant date but I just cannot use variable on it.
你能帮我解决一下这个问题吗?
Could you please help me on how to do this ??
提前致谢!!
推荐答案
欢迎来到MSDN论坛。
Welcome to the MSDN forum.
这个队列是关于vb.net的。我担心你关于VB6的话题不适合这里。我会把这个帖子移到主题论坛。你可以通过这个链接找到正确的论坛:
http://social.msdn.microsoft.com/Forums/en-US/vbgeneral/thread/6a0719fe-14af-47f7-9f51-a8ea2b9c8d6b 。
This queue is about vb.net. I’m afraid that your topic about VB6 is unsuitable here. I will move this thread to off topic forum. You can find the correct forum with the help of this link:http://social.msdn.microsoft.com/Forums/en-US/vbgeneral/thread/6a0719fe-14af-47f7-9f51-a8ea2b9c8d6b.
很抱歉给您带来不便,祝您有个愉快的一天。
Sorry for any inconvenience and have a nice day.
这篇关于VB6编写动态数据源并在EXCEL 2007/2010工作表中刷新结果的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!