Hi GUYS!!!

I am a newbie here. I just want to make friends and need some help about my nightmares.
Here is my problem.

I use a batch file to transfer my DATA from a barcode device to a MS Access.
But Unfortunately, I got stuck in how to transfer the data to MS Access.

This is what I made.

Echo off
C:\BARCODE\test1.mdb %1 %2 %3 %4

For other details on the MS Access side.

File Name: test.mdb
Table Name: data
Fields: field1,field2,field3,field4

I really need your advice on this situation.

Thanks and I really appreciate any advice regarding this problem.

pralphsave ur data into a .csv file and then do this command then it will open the wizard for u

start MSACCESS.EXE c:\filename.csv

u can save ur data in to a csv file simply by doing this

echo %first_feald_name%,%secound_feald_name%,%thrd_feald_name% >c:\filename.csv
echo %feald1_data%,%feald2_data%,%feald3_data%>>c:\filename.csv
echo %feald1_data%,%feald2_data%,%feald3_data%>>c:\filename.csv
echo %feald1_data%,%feald2_data%,%feald3_data%>>c:\filename.csv

infact i am not fameliar with msaccess put in oracle u can us the sql loader to load data into ur database , u should search if access got the import facility

i hope its usfu :)l


Hi .bat_man,

Thanks for your advice....You really saved my skin.

I will try to execute the command that you gave me. And if it works,lets have some beer!

Thanks, I hope to HEAR from you one day again.

pralphwelcom and i hope it works after u make ur csv file, create a macro in access to transfer the file from the csv to the access table. the action command in access is transfertext. Also add an action of Quit with an exit option, Then in ur bat file start access and call the macro. This is done by

"C:\Program Files\Microsoft Office\Office11\msaccess.exe" "\your database.mdb" /x yourMacroname

This STARTS access and opens ur database. it will run the maco you passed which will transfer the data in the csv file to the table u specify in the transfer text commandCayuga Bob,

Thanks for the advice....I really appreciate your ideas that you gave me...It was helpful too.

.bat_man,

It worked!!!...I guess its the same as Oracle...thanks .bat_man...wish could give you some beers!!!


Pralph