Idea for importing!

[Beatrix Willius]

Hi Greg,

when importing data to Access I use the following:

- Import the data into a table with generic field types.
- Create an empty table with the correct field types.
- Append the imported data to the empty table.

Haven't done this in Valentina, though.

HTH

Trixi

Greg Olson-Hyde wrote: 

>When I export my data from SQLite, ALL fields are enclosed with "".  
>When imported into Valentina the integer fields seem to cause  
>Valentina to quit.
>
>However, if I make all fields VarChar or Text, the import goes fine.  
>Ruslan says he doesn't recommend changing form VarChar to Long or  
>Short while the fields contain data, so, I was thinking this may be a  
>good idea:
>
>1. Create a table of all VarChar with my correct field names.
>
>2. Import the data.
>
>3. Change the field types to Long, Short and Date as required.
>
>4. Export the data - no more "" enclosing Long, Short and Date fields.
>
>5. Scrap the table.
>
>6. Create a new table with correct field names and types.
>
>7. Re-import the data - done!
>
>Anyone see any problems with this - will it screw up the data or cause  
>any other problems?
-- 
GRATIS für alle GMX-Mitglieder: Die maxdome Movie-FLAT!
Jetzt freischalten unter http://portal.gmx.net/de/go/maxdome01