Copying data in Base changes Field Types to VARCHAR

I’m new to LO and setting up a db previously in Access which was run on a Mac through Parallels, LO on same machine and s/w… Have set up db, forms and reports but am having a problem as when pasted data into Base from Calc its resetting defined Field Types from Date or Decimal to Text (VARCHAR). I am obviously doing something wrong but its driving me mad and have tried many variations to try and sort it! My problem is that am unable to total a column on a report as not Decimal, important report as well. Apologies if a repeat question and many thanks. Phil
Even with this issue have to say am very impressed with the SW and enjoyable using it.

Hello,

In creating a table from Calc data, you need to use the Next button to step through the process & insure the field types are correct. Here is a quick example.

Data in Calc copied. Pasted in Base table section. Used Next button to get to :

You can see amount field is set as varchar.

Make appropriate changes:

When finished:

image description

Note. In this example I let the system generate a primary key field - ID.

Not sure where to answer and thank you! The simplest solution, I was looking too deeply. Thanks very much, Phil

@Hampers,

What you did is fine. Glad all has worked out for you.