I need to work with a database of my suppliers products. This record is supplied to me as a Excel or CSV file. I am trying to get this into Alpha5 to work with it.I have tried everything and still i cannot get it done properly. I hope it can actually be done and someone can help me.
I have tried saving the Excel file as CSV, Excel Worksheet, DBF and Excel 4.0. I get mixed result which are allways unacceptable.
The main problem is that this file has a discription field (usually in HTML). It is absolutely essential that the complete field be imported, or I will have end up editing them singularly. This file has over 3000 record. So i cannot accept this option.
For starters, when i save the file as Excel 4 (as required by Alpha5)the conversion cuts off a part of the discription. So this narrows my option of file formats to work with to CSV, DBF, and excel worksheet format.
first i tried USE IMPORT GENIE. > File type > EXCEL
SPREADSHEET (4.0). Then edit the field structure before
completing, I would find that I have a pretty decent
result, except that I have to contend with the Alpha 5
Excel 4.0 limitation. Which inherited the cut off
discription field. Best result so far, but I need the
full description field imported, so I will not have to
edit 3000+ records
next i tried USE IMPORT GENIE. > File type > ASCII text
file. > import data into a new table > Character
delimited format > etc, etc This is the worst one. No
record imported plus Alpha 5 locks up and I have to do a
ctrl/Alt/Delete to continue to work on my computer
then i try saving file in dBase 4 file. i use the Add
Table/Set which appears to be easy and works fine
(imports all the records)until I realize that pretty
much all fields are cut off. The discription field would
only be little more than 10 characters, as well as all other fields-This is totally unacceptable
use import ODBC WITH regular EXCEL worksheet > Next >
SELECT EXCEL> SELECT FIELDS>REFRESH qUERY> CLICK ON NEXT
(ERROR: Convert: unable to open *\*\*\masterData.dbf)
(ERROR: Script: Template: Line 1, unable to find or open
memo file)
Also: use import ODBC WITH EXCEL4 > Next > SELECT EXCEL>
SELECT FIELDS>REFRESH qUERY> CLICK ON NEXT
(ERROR: THE PROCESS CANNOT ACCESS THE FILE BECAUSE IT IS
BEEN USED BY ANOTHER PROCESS)
OF COURSE IT ONLY IMPORTS 720 OF 3000+ RECORDS. This is
no use to me anyhow because it imports records with the
discription field cut short
Nothing seems to work. I am desperate. Can someone please tell me how to do this.
Thanks
I have tried saving the Excel file as CSV, Excel Worksheet, DBF and Excel 4.0. I get mixed result which are allways unacceptable.
The main problem is that this file has a discription field (usually in HTML). It is absolutely essential that the complete field be imported, or I will have end up editing them singularly. This file has over 3000 record. So i cannot accept this option.
For starters, when i save the file as Excel 4 (as required by Alpha5)the conversion cuts off a part of the discription. So this narrows my option of file formats to work with to CSV, DBF, and excel worksheet format.
first i tried USE IMPORT GENIE. > File type > EXCEL
SPREADSHEET (4.0). Then edit the field structure before
completing, I would find that I have a pretty decent
result, except that I have to contend with the Alpha 5
Excel 4.0 limitation. Which inherited the cut off
discription field. Best result so far, but I need the
full description field imported, so I will not have to
edit 3000+ records
next i tried USE IMPORT GENIE. > File type > ASCII text
file. > import data into a new table > Character
delimited format > etc, etc This is the worst one. No
record imported plus Alpha 5 locks up and I have to do a
ctrl/Alt/Delete to continue to work on my computer
then i try saving file in dBase 4 file. i use the Add
Table/Set which appears to be easy and works fine
(imports all the records)until I realize that pretty
much all fields are cut off. The discription field would
only be little more than 10 characters, as well as all other fields-This is totally unacceptable
use import ODBC WITH regular EXCEL worksheet > Next >
SELECT EXCEL> SELECT FIELDS>REFRESH qUERY> CLICK ON NEXT
(ERROR: Convert: unable to open *\*\*\masterData.dbf)
(ERROR: Script: Template: Line 1, unable to find or open
memo file)
Also: use import ODBC WITH EXCEL4 > Next > SELECT EXCEL>
SELECT FIELDS>REFRESH qUERY> CLICK ON NEXT
(ERROR: THE PROCESS CANNOT ACCESS THE FILE BECAUSE IT IS
BEEN USED BY ANOTHER PROCESS)
OF COURSE IT ONLY IMPORTS 720 OF 3000+ RECORDS. This is
no use to me anyhow because it imports records with the
discription field cut short
Nothing seems to work. I am desperate. Can someone please tell me how to do this.
Thanks
Comment