DBF

  • Thread starter Thread starter Mauricio R.
  • Start date Start date
M

Mauricio R.

Hello all.........
I have a worksheet that keeps track of my daily sales
and inventory, and then is send to 5 diferent workbooks,
so far I been doing it by copying each data cell to a
common workbook called Data, and then copy it to the
diferent workbooks using vb, is there a way to have this
save in a DBF format, my data from the main WB it'snt
sort in any way and I would like to save this resolts in
case of any problem I can go back and exportem from my
DBF file base it on the day .
my inform. gose something like this:

Hrly sales inv In inv Out transf theo usage
11:00 100.00 95.00 12.00 98.00
12:00
etc..
Can some one plz. help me with my little problem, if you
can, I'm selfteaching and I need alot of help with this
so plz. be as explisit as you can. you can contac me for
more details if you like.

Thanks...
 
Just do File/SaveAs and pick one of the DBase "Save as type".

Make sure that your columns are wide enough to show all the data befor
saving because this format uses a fixed column width
 
I guess I did'nt expl. myself right, I know how to save the WB as DBF,
my problem it's that once I do than, i get and err. regarding the path
and range of the file, how can I get to act. use the fanction of a
database using the dbf format from xls. and import and export data from
and to diferent WB on a daily basics.
 
Back
Top