topic Re: Changing Data Source Type in QlikView https://community.qlik.com/t5/QlikView/Changing-Data-Source-Type/m-p/411895#M1162776 <HTML><HEAD></HEAD><BODY><P>But I'm betting that Access would be a safer bet than a simple Excel file in the transition, right?</P></BODY></HTML> Wed, 07 Nov 2012 15:10:52 GMT 2012-11-07T15:10:52Z Changing Data Source Type https://community.qlik.com/t5/QlikView/Changing-Data-Source-Type/m-p/411893#M1162774 <HTML><HEAD></HEAD><BODY><P>Is it possible to create a QVW that's looking at an Excel file as a data source and then later change the data source to a proper database? Let's assume that the tables in the data base are the same as the tabs in the Excel file. Woudl the same work for moving from an Access database to a larger database later? I'm just looking to start some development before the server and a proper database is up and running.</P><P></P><P>Thanks in advance for the help!</P><P>Jason</P></BODY></HTML> Wed, 07 Nov 2012 14:45:30 GMT https://community.qlik.com/t5/QlikView/Changing-Data-Source-Type/m-p/411893#M1162774 2012-11-07T14:45:30Z Re: Changing Data Source Type https://community.qlik.com/t5/QlikView/Changing-Data-Source-Type/m-p/411894#M1162775 <HTML><HEAD></HEAD><BODY><P>Both aren't too hard. If you are going to use excel consider retrieving data from excel through an odbc connection. That way you're treating Excel about the same as you would any other database. That will make it easier to migrate later. </P></BODY></HTML> Wed, 07 Nov 2012 14:51:12 GMT https://community.qlik.com/t5/QlikView/Changing-Data-Source-Type/m-p/411894#M1162775 Gysbert_Wassenaar 2012-11-07T14:51:12Z Re: Changing Data Source Type https://community.qlik.com/t5/QlikView/Changing-Data-Source-Type/m-p/411895#M1162776 <HTML><HEAD></HEAD><BODY><P>But I'm betting that Access would be a safer bet than a simple Excel file in the transition, right?</P></BODY></HTML> Wed, 07 Nov 2012 15:10:52 GMT https://community.qlik.com/t5/QlikView/Changing-Data-Source-Type/m-p/411895#M1162776 2012-11-07T15:10:52Z