how do I import alpha/numeric data from a delimited text file?

R

Red

I am still having problems importing an alpha/numeric data field into an
existing table. The numeric cells import but the alpha/numeric do not. The
table cells are blank and an error table is created which slowly increases
the size of the database (not what I want to do). The data comes from the ^
delimited text file into an access table and then some of the columns are
moved to a final access table which is used for processing/delivering the
data to user. The column in both tables are set to text.

If anyone has suggestions, it will be greatly appreciated.
Thanks,
Red
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding data to MS Access from csv file 0
Importing Excel Spreadsheet into Access 2000 3
query to show where no data in a stated column 0
Query to show details of dataset when one type of data is still blank 1
Type Conversion Failure importing number as text 1
Import from Notepad delimited text 7
Parsing a Comma Delimited Values File 5
Problems importing "number/text" fields to Access from Excel 2

Top