hi,
I use this code to import data from TXT file into MSAccess .
**************
conDB.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0; " & _
"Persist Security Info=False; " & _
"Data Source=" & rngDBFileName.Value
conDB.CursorLocation = adUseClient
conDB.Open
strSQL = "INSERT INTO tblBasicData_Import (" & _
"[Country],[Calendar year],[Global Customer]),.......and next colums " & _
"SELECT " & _
"[Subsidiary],[Calendar year],[Global Customer], .......and next colums" & _
"FROM [" & FileName & "] in """ & FolderName & """ ""Text;HDR=Yes;"""
conDB.Execute strSQL
************
Problem is that on some computers this work correctly and on some others computers this dosnt work. In the same directory exists file schema.ini in this format:
[Sample_data_final_0_0_5.csv]
ColNameHeader=True
Format=Delimited(;)
CharacterSet=OEM
DecimalSymbol=,
NumberLeadingZeros=True
Col1="Subsidiary" Text Width 255
Col2="Calendar year" Long Width 4
.....and next columns
What should I check or install on problem computers to solve this problem Any idea
Thanks for help
Vladislav U.
List of all necessary conditions and installed DLLs to import data from TXT files using ADO
Musa_Tariq_Raza
"conDb.Execute strSQL" command gives Error msg in this wording:
Erreur d'execution '-2147217904 (8J040e10)':
No value given for one or more required parameters.
Other useful information:
Application was created in MS Excel 2003 using VBA (Czech version), Windows XP SP2 (Czech version).
Target Operating system: Windows XP SP2, English version
Target Excel: MS Excel 2003, French version
I installed MDAC 2.8 on target computer.
Yesterday I instaled Vitual PC 2004 on my own computer, and clear Windows XPSP2 and only Excel 2003 (both in Czech version and standard instalation). And I didnt install any MDAC. Result of this try is, the application works corretly.
Rowdy19
I would double check your query. Do you have any items inside of "[" and "]" that does not match, exactly, the name of a column or sheet If so, the jet engine is probably interpreting them as a query parameter, hence the error message.
-Scott
U_T_A
jason d
Could you clarify what you mean by "This Doesn't Work".
Do you receive errors when you try to open the connection or when you try to run the command
What is the error that you receive
mike miller
Make sure the latest and greatest version of the MDAC is installed. You can get it here:
http://msdn.microsoft.com/data/ref/mdac/downloads/
S10n
Yes, I have. And I thing this is source of this problem.
I renamed all columns to more standard form (e.g. Customer_Name,...) , I updated schema.ini file and now application works correctly everywhere.
Do you know reason why the original code works on some environments and doesnt work on others
Thank you a lot for your help.