Format error Schema.ini withTransfertext
-
Hi Y'all I'm trying to import a text file into my Access 2000 database using the VBA function TransferText: Dim db As DAO.Database Set db = WerkDatabase db.Execute _ "SELECT * INTO TempArtikel FROM [Text;FMT=FixedLength;HDR=No;DATABASE=" + ImportDir + ";].[artikel#asc];", _ dbFailOnError db.TableDefs.Refresh My schema.ini file is located in the same directory as the text file, and looks something like this: [artikel.asc] ColNameHeader=False Format=FixedLength MaxScanRows=0 CharacterSet=OEM ARTNAR="ARTNAR" Number Width 15 OMS1AR="OMS1AR" Char Width 30 INHDAR="INHDAR" Number Width 5 PALCAR="PALCAR" Number Width 8 Where ARTNAR is the name of the column in the target database table (TempArtikel). The problem is that ADO gives me the following error message: 3443 Can't create fixed width text file without column specification which is pretty weird, because I did specify a length (15), right? What am I doing wrong here? :confused: