Link csv file to a new table Column lenght defaulted to 255 ???

G

Guest

I'm trying to link a "csv" file to a table in access. File ";" delimited so
I linked it named a new table formated everything looks ok for the
exception of all the columns have lenght of 255.
Q: is there anyway to change the lenght ?
Becuase I have other app that reads this table and it can't handle long
variables.

Thank you for any help.
 
D

Douglas J. Steele

I don't believe there is any way to change it for a linked table. However,
perhaps you can create a query that uses the Left() function on the various
fields, shortening them to whatever length you want, and have your other app
read the query instead of the table.
 

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

Export Access Query to a pipe delimited .csv file 5
cannot link Foxpro file as table, access2000 3
Copy data to new table & link - how? 2
Have a dialog box link a file loction to a textbox 1
Code to change a table definition 3
update multiple tables from .csv or .xls file 4
unable to import from csv to memo field 1
Import CSV file and adding the filename as a field 3

Top