Devart Forums

Hi,
I'm loving DBforge so far but have run into a snag. I'm trying to import a table that has ~400 columns. Each column has data with ~10 decimal points. After I import the data dbforge always cut it down to points.

Any quick way of just changing the type of all of these to something like text when I import

Can you send us a sample of the imported file?

Here's the file:

http://dl.dropbox.com/u/530959/All%20Fi ... 272010.csv

I originally tried this as a XLSX and it wouldn't give me the right number of digits. I tried it as a CSV and it sets all the columns to VAR(255) but then complains that I have too many rows. I only have something like 350.

1. Create a new table with required types and column lenghs. Import from CSV format to a created table.
2. While importing from CSV, on the Mapping wizard page specify correctly column types and set a required lengh.

...but then complains that I have too many rows

Total of varchar data lenghs in columns of one row should not exceed 65535.
VAR(255)*~400 =~102000

Is there a way to change the types of all the columns at once or do I have to go through and change each one manually.

There is no possibility to change data types of all the columns simultaneously. You should set each column type manually.