1 (edited by mahbooobma 2016-11-04 08:03:09)

Topic: Excel file

Is it possible the required information from an Excel file into the project

Hello
For the record output is projected as an Excel file option
Whether to enter data via Excel file records can be applied?

Re: Excel file

Please provide more details about your question.

Dmitry.

Re: Excel file

DriveSoft wrote:

Please provide more details about your question.

Hello
For the record output is projected as an Excel file option
Whether to enter data via Excel file records can be applied?

Re: Excel file

Unfortunately I can't understand your question.

Dmitry.

Re: Excel file

DriveSoft wrote:

Unfortunately I can't understand your question.

I want to know whether the information from the Excel file into the fields?
As the extracted information in an Excel file

Re: Excel file

Hopefully I am understanding your question. You cannot import an Excel file directly. However you can save your Excel file as "CSV" format and import into MVD. If you are only importing one time, you may consider using something like Sqllite Studio to do the import. If it will be an ongoing import, then you can use the script from the following post example to do your import within your project. 


[http://myvisualdatabase.com/forum/viewt … 806#p14806]

Re: Excel file

ehwagner wrote:

Hopefully I am understanding your question. You cannot import an Excel file directly. However you can save your Excel file as "CSV" format and import into MVD. If you are only importing one time, you may consider using something like Sqllite Studio to do the import. If it will be an ongoing import, then you can use the script from the following post example to do your import within your project. 


[http://myvisualdatabase.com/forum/viewt … 806#p14806]

Yes
My goal was
But I have a lot of fields
  I want to import from Excel file
What is the solution?

Re: Excel file

Hello mahbooobma

If you use the script proposed by ehwagner and JB (but I know this guy well !!!), you have no other choice to adapt it to each fields in your Excel file.
If there are many, it will be necessary to be patient and to describe them one after the other.
But this script is very reliable and I use it several times (I have been up to twenty fields). You have to be careful to avoid mistakes and many correction.
But I went through that too and it can be frustrating

Good luck

JB