We did this during our initial Trac setup using MS Access and the
Postgres ODBC driver. Create linked tables in Access for the
spreadsheet and the ticket table, then use an append query to copy the
data from one the other. One gotcha: the dates in Trac are stored as
Unix timestamps in integer type fields, so you need to convert Excel/
Access dates using the expression "time: DateDiff("s",#12/31/1969
7:00:00 PM#,[excelDateField])".- Matthew Carlson On May 30, 6:06 am, Nora <[EMAIL PROTECTED]> wrote: > I am trying to determine the most efficient method to import a two > column spreadsheet (one column with all the‘tickets’ Names and the > other one, with Codes), into TRAC. > > Should I detour into Access? Use a text file? > Any ideas??? > > Thanking you in advance, --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Trac Users" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/trac-users?hl=en -~----------~----~----~----~------~----~------~--~---
