Click here to Skip to main content
16,005,491 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralPrinting in draft mode in VB Pin
Deepak Satam29-Oct-01 8:01
Deepak Satam29-Oct-01 8:01 
GeneralRe: Printing in draft mode in VB Pin
Derec Roofie12-Nov-02 6:16
Derec Roofie12-Nov-02 6:16 
Generalcommand/buttons help- send a character to a text box HELP!!! Pin
29-Oct-01 1:11
suss29-Oct-01 1:11 
GeneralRe: command/buttons help- send a character to a text box HELP!!! Pin
1-Nov-01 11:22
suss1-Nov-01 11:22 
GeneralA Challanging JOB Pin
28-Oct-01 18:20
suss28-Oct-01 18:20 
GeneralRe: A Challanging JOB Pin
Michael P Butler29-Oct-01 1:34
Michael P Butler29-Oct-01 1:34 
QuestionTab Control Or Property Sheet?? Pin
Shrirang28-Oct-01 4:41
Shrirang28-Oct-01 4:41 
GeneralFormat error Schema.ini withTransfertext Pin
P. Bogerd21-Oct-01 23:42
P. Bogerd21-Oct-01 23:42 
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 | :confused:

QuestionAccessing VB3/4 Program Workspace? Pin
TheRealGuru18-Oct-01 22:45
TheRealGuru18-Oct-01 22:45 
GeneralOne Class two forms Pin
Rotti17-Oct-01 3:18
Rotti17-Oct-01 3:18 
GeneralRe: One Class two forms Pin
Oyvind Bratland19-Oct-01 3:28
Oyvind Bratland19-Oct-01 3:28 
GeneralOpen - change and save AScii in visual Basic problem Pin
16-Oct-01 21:16
suss16-Oct-01 21:16 
GeneralRe: Open - change and save AScii in visual Basic problem Pin
19-Oct-01 23:23
suss19-Oct-01 23:23 
General2048 command line limit Pin
Jerkan15-Oct-01 3:49
Jerkan15-Oct-01 3:49 
GeneralRe: 2048 command line limit Pin
Daniel Turini22-Oct-01 23:23
Daniel Turini22-Oct-01 23:23 
GeneralRe: 2048 command line limit Pin
Jerkan23-Oct-01 0:35
Jerkan23-Oct-01 0:35 
GeneralRe: 2048 command line limit Pin
Daniel Turini23-Oct-01 0:54
Daniel Turini23-Oct-01 0:54 
GeneralRe: 2048 command line limit Pin
Jerkan23-Oct-01 1:03
Jerkan23-Oct-01 1:03 
GeneralRe: 2048 command line limit Pin
Jerkan23-Oct-01 1:32
Jerkan23-Oct-01 1:32 
GeneralRe: 2048 command line limit Pin
Jerkan2-Nov-01 0:32
Jerkan2-Nov-01 0:32 
Generaluser-defined types Pin
15-Oct-01 2:18
suss15-Oct-01 2:18 
GeneralRe: user-defined types Pin
22-Oct-01 0:28
suss22-Oct-01 0:28 
GeneralSearching Message Headers in Outlook 2002 Pin
WebWham13-Oct-01 7:59
WebWham13-Oct-01 7:59 
GeneralEmailing from VB Pin
Obliterator11-Oct-01 6:09
Obliterator11-Oct-01 6:09 
GeneralRe: Emailing from VB Pin
David Salter16-Oct-01 10:14
David Salter16-Oct-01 10:14 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.