Transfer Data from CSV file to MS Access 2003

[akashuae]

Hi

I am trying transfer data from CSV to Ms Access. But I could not make it. It shows that Action Failed.

Macro Name : Macro file Name which I make
Condition : True
Action Name : Transfer Text
Argument : 0, , Raw, C:\TBA41X.CSV, No, ,

Can you help me what is actual problem?

[zmbd]

akashuae:
You'll find very limited help here for Macros and most of us have moved on from ACC2003 to at least ACC2007.
Most of us simply do not use them, especially in ACC2003.
There is no error trapping, and as you have discovered, the error messages are useless.

Macro Name : Macro file Name which I make
Condition : True
Action Name : Transfer Text
Argument : 0, , Raw, C:\TBA41X.CSV, No, ,

You're missing the table that you want to transfer the text into - the issue here is that I cannot tell you where to insert the value because I nolonger have a ACC2003-Macro reference and the web documentation is quickly vanishing.

However, from the VBA equivalent:
TransferText Method [Access 2003 VBA Language Reference] (Office 2003) You can see that there should be a table reference in your macro. The macro editor should have a field for that information. NO the macro will not create a table based on the file name, you MUST specify it.

>>> VERY IMPORTAINT <<<
In ACCESS - MACRO does NOT mean VBA! These are two seperate codeing languages within ACC. They are NOT interchangable terms within this context although, each can call and execute the other. In EXCEL, these terms are one and the same which has caused much confusion for the unsuspecting programmer!