Transferring Blaise Data to Access

  • Thread starter Thread starter MB
  • Start date Start date
M

MB

Has anyone had problems transferring data collected in
Blaise format to an Access Database. Data is collected
through an interactive application written in Blaise. The
data is then transferred to a txt file and then the text
file is imported to Access for Warehousing. When checking
the Blaise key strokes the data appears to be collected in
the correct format [proper skip patterns] however when we
look at the data in access there is erroneous data in some
fields.
Thanks
MB
 
txt is not a 'standard' format. There are as many different
variations as there are programs. Check the txt file and
see if it looks reasonable. You may have to write VBA code
to do the import instead of using SQL or ImportText.

(david)
 
Back
Top